学然后知不足，教然后知困

摘要： select step_id,run_status,run_date As rundate--a.run_time, a.* from msdb.dbo.sysjobhistory a inner join msdb.dbo.sysjobs b on a.job_id=b.job_idwhere b.name='PCDBI'order by run_date DESC,step_id Asc作业的执行状态run_status： 0 = 失败1 = 成功2 = 重试3 = 取消4 = 正在进行-------------------------------------------- 阅读全文