SQL Server Agent Job'larının Son Çalışma Durumu

SELECT j.name AS job_name, j.enabled,
       CASE h.run_status WHEN 0 THEN 'Failed' WHEN 1 THEN 'Succeeded' WHEN 2 THEN 'Retry'
                         WHEN 3 THEN 'Canceled' ELSE 'Unknown' END AS last_status,
       msdb.dbo.agent_datetime(h.run_date, h.run_time) AS last_run,
       h.message
FROM msdb.dbo.sysjobs j
OUTER APPLY (SELECT TOP 1 * FROM msdb.dbo.sysjobhistory
             WHERE job_id = j.job_id AND step_id = 0 ORDER BY instance_id DESC) h
ORDER BY CASE WHEN h.run_status = 0 THEN 0 ELSE 1 END, last_run DESC;