SQL SERVER查询Job每个步骤执行结果情况

最新推荐文章于 2023-09-13 00:55:51 发布

xiongnanbin

最新推荐文章于 2023-09-13 00:55:51 发布

阅读量1.5k

点赞数

分类专栏： SQL SERVER

本文链接：https://blog.csdn.net/xiongnanbin/article/details/24582619

版权

SQL SERVER 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

 
  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)) 
 