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 : http://msdn.microsoft.com/en-us/library/ms186722(SQL.105).aspx

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: