Check Sys Jobs

SELECT sj.name AS [JobName],
sjh.step_id AS [Step],
sjh.step_name AS [StepName],
sjh.message AS [Message],
CASE WHEN sjh.run_status = 0 THEN 'Failed'
WHEN sjh.run_status = 1 THEN 'Succeeded'
WHEN sjh.run_status = 2 THEN 'Retry'
WHEN sjh.run_status = 3 THEN 'Canceled'
END AS [Status],
sjh.run_date AS [RunDate],
sjh.run_time AS [RunTime],
sjh.run_duration AS [Duration]
FROM        msdb..sysjobs sj
INNER JOIN  msdb..sysjobhistory sjh ON sjh.job_id = sj.job_id
ORDER BY    sjh.run_date, sjh.run_time

-- 參考
-- 忘了