SQL SERVER查询Job每个步骤执行结果情况
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] AND [jobhis].[run_status] = 0)
INNER JOIN [dbo].[sysjobsteps] AS jobstep WITH(NOLOCK)
ON ([job].[job_id] = [jobstep].[job_id] AND [jobstep].[step_id] = [jobhis].[step_id])
--run_date是步骤执行的时间
WHERE [jobhis].[run_date] = CONVERT(INT, CONVERT(NVARCHAR(8), DATEADD(dd, -1, GETDATE()), 112))
[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] AND [jobhis].[run_status] = 0)
INNER JOIN [dbo].[sysjobsteps] AS jobstep WITH(NOLOCK)
ON ([job].[job_id] = [jobstep].[job_id] AND [jobstep].[step_id] = [jobhis].[step_id])
--run_date是步骤执行的时间
WHERE [jobhis].[run_date] = CONVERT(INT, CONVERT(NVARCHAR(8), DATEADD(dd, -1, GETDATE()), 112))
作者:DataStrategy
出处:https://www.cnblogs.com/xiongnanbin/
联系:1183744742@qq.com;xiongnanbin@126.com
本文版权归作者和博客园共有(转载的归原作者所有),欢迎转载,但是请在文章页面明显位置给出原文连接。如有问题或建议,请多多留言、赐教,非常感谢。