Data World

SQL Server -Find currently Running jobs

Posted by Pramod Singla on June 19, 2012

If you want to find the currently running jobs then following queries will help you.

  • List All Currently Running SQL Agent Jobs:
exec msdb..sp_help_job @execution_status=1
  • List Extra Information about your Job:
exec msdb..sp_help_job @Job_name=<yourjobname>
  • Possible values of @execution_status:
Value Description
0 Returns only those jobs that are not idle or suspended.
1 Executing.
2 Waiting for thread.
3 Between retires.
4 Idle.
5 Suspended.
7 Performing completion actions.

Links :

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s