작업스케줄러 실패 모니터링

작업스케줄러 실패 모니터링

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