Tuesday, March 1, 2011

How to get information which jobs are executing currently through T-SQL

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

No comments:

Post a Comment