House 9: Get list of MSSQL jobs that are currently running

The blog has moved to http://jessehouse.com/ ... Many google searches point here so I am leaving it operational, but there will be no new posts.

Tuesday, August 4, 2009

Get list of MSSQL jobs that are currently running

The following sql statement will return information about the currently executing MSSQL jobs.

Run it against the msdb database

EXEC dbo.sp_help_job @execution_status = 0;

view raw gistfile1.sql hosted with ❤ by GitHub

Resources

No comments:

Subscribe to: Post Comments (Atom)