Twit This!
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
This entry was posted
on Saturday, May 3, 2008
at Saturday, May 03, 2008
and is filed under
SQL Queries
. You can follow any responses to this entry through the
comments feed
.
_507_Rez.jpg)
