摘要: 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 = 正在进行-------------------------------------------- 阅读全文
posted @ 2012-08-15 11:31 牛伯温 阅读(1635) 评论(0) 推荐(0) 编辑