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.
Where is the "job" status stored for a scheduled job.
I can see this status in the administrator but want to
be able to provide this status to a user via a different
I can find the job and the job history, runtime ect ...
where is the "status" stored or is it some calculated
value based on instance ect ...
7. Job status
8. Msg 7995
9. Job Status