November 10, 2011 by Xart
SELECT ss.last_run_outcome /*1-Success,0-Fail*/
FROM msdb.dbo.sysjobs s INNER JOIN msdb.dbo.sysjobservers ss
ON s.job_id = ss.job_id
WHERE s.name= ‘Job_Name’
Posted in Database | Leave a Comment
Comments RSS
Δ
Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Email Address:
Sign me up!
Leave a comment