magritton
7/6/2015 - 1:29 AM

SQL Agent history and log information

SQL Agent history and log information

SQL Agent History.sql
content_copyfile_download
use msdb
go
exec sp_help_jobhistory
exec sp_help_jobsteplog @job_name='Random Data'--,@step_id=1
exec sp_help_jobstep @job_name = 'Random Data'
exec sp_help_jobactivity @job_name = 'Random Data'