[2k5] SQL Server Agent 실패 작업(JOB) 모니터링

/********************************************************************************************
-- Title : [2k5] SQL Server Agent 실패 작업(JOB) 모니터링
-- Reference : wipscorp.com 김민철
-- Key word : agent job 에이전트 작업
********************************************************************************************/

        SELECT sysjobs.name
             , sysjobs.description
             , sys_srvs.last_run_outcome
             , sys_srvs.last_outcome_message
             , sys_srvs.last_run_date
             , sysjobschedules.next_run_date
        FROM msdb.dbo.sysjobs AS sysjobs
        INNER JOIN msdb.dbo.sysjobservers AS sys_srvs
        ON sysjobs.job_id = sys_srvs.job_id
        LEFT OUTER JOIN msdb.dbo.sysjobschedules as sysjobschedules
        ON sysjobs.job_id = sysjobschedules.job_id
        WHERE sys_srvs.last_run_outcome = 0; --실패JOB