Archive for the ‘Jobs’ 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 


exec sp_get_composite_job_info @execution_status=1


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,
7 = PerformingCompletionActions

Categories: Jobs