Get the List of Failed Jobs | SansSQL

Saturday, May 3, 2008

Get the List of Failed Jobs

use msdb
SELECT name FROM msdb.dbo.sysjobs A, msdb.dbo.sysjobservers B WHERE A.job_id = B.job_id AND B.last_run_outcome = 0

No comments:

Post a Comment