Archive

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

Categories: Jobs