摘要： SELECT[job].[job_id],[job].[name] AS 'job_name',[jobstep].[step_id],[jobstep].[step_name],[jobhis].[message] AS 'err_mess'--步骤失败的原因FROM [dbo].[sysjobs] AS job WITH(NOLOCK)INNER JOIN dbo.[sysjobhistory] AS jobhis WITH(NOLOCK)--run_status=0代表失败步骤ON ([job].[job_id] = [jobhis].[job_id] A 阅读全文