SQL SERVER 查询Job作业基本信息及执行情况
SELECT. AS '作业唯一标示符'
,. AS '作业名称'
, CASE WHEN . IS NULL
OR . IS NULL THEN NULL
ELSE CAST ( CAST (. AS CHAR ( 8 )) + ' '
+ STUFF(STUFF( RIGHT ( '000000'
+ CAST (. AS VARCHAR (6)),6),3,0,':'),6,0,':') AS DATETIME) END AS '最后执行时间'
, CASE .
WHEN 0 THEN '失败'
WHEN 1 THEN '成功'
WHEN 2 THEN '重试'
WHEN 3 THEN '取消'
WHEN 4 THEN '正在运行'
END AS '最后执行状态'
,STUFF(STUFF( RIGHT ( '000000' + CAST (. AS VARCHAR (6)),6),3,0,':' ),6,0,':') AS '最后运行持续时间'
,. AS '最后运行状态信息'
, CASE .
WHEN 0 THEN NULL
ELSE CAST ( CAST (. AS CHAR ( 8 )) + ' '
+ STUFF(STUFF( RIGHT ( '000000'
+ CAST (. AS VARCHAR (6)),6),3,0,':'),6,0,':') AS DATETIME) END AS '下次运行时间'FROM .. AS LEFT JOIN ( SELECT
, MIN () AS
, MIN () AS
FROM ..
GROUP BY
) AS
ON . = .LEFT JOIN ( SELECT
,
,
,
,
,
,ROW_NUMBER() OVER ( PARTITION BY ORDER BY DESC , DESC ) AS RowNumber FROM ..
WHERE = 0
) AS
ON . = .
AND . = 1ORDER BY .
页:
[1]