Very Computer

by **Jon** » Thu, 26 Jun 2003 16:58:42

Is there a way to tell if a job is currently executing? I
have to create a proc that first checks to see if another
job is executing. If it is, it will need to do different
logic than if the job is not running.

by **Drew Seal** » Thu, 26 Jun 2003 17:08:05

You can use the procedure sp_help_job to check information regarding
scheduled tasks. Since all jobs are stored in msdb, you will need to
execute that against that db. You can find everything you with that proc.
If you want something more specific, just review the text of the procedure
to isolate the information you want.

Hope that helps

Quote:> Is there a way to tell if a job is currently executing? I
> have to create a proc that first checks to see if another
> job is executing. If it is, it will need to do different
> logic than if the job is not running.

Very Computer

Job status

Job status

Job status