Archive for the ‘SQL Server Agent’ Category
Check Running Jobs Status
January 2, 2011
Leave a comment
I am not sure how many DBA are really interested to know, is there a way to get all running jobs status and other information from Query Analyzer.
I got to know this when I have to monitor more than 100+ jobs. I really have to put great effort to know what all jobs are running at a time and much more
USE msdb
GO exec sp_get_composite_job_info @execution_status=1 GO |
Other parameter for @execution_status
@execution_statusĀ =
0 = Not idle or suspended, 1 = Executing, 2 = Waiting For Thread, 3 = Between Retries, 4 = Idle, 5 = Suspended, 6 = WaitingForStepToFinish, |
Categories: Jobs