Script to check Job history of a particular job.

use msdb
go
select * from sysjobhistory sjh
join sysjobs sj
on sjh.job_id =sj.job_id
where sj.name='<Your Job Name here>'
go 
This entry was posted in SQL Server, T-SQL Scripts and tagged , . Bookmark the permalink.

Leave a Reply