Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

simple requestion: QUERY to find out CURRENTLY executing jobs

Status
Not open for further replies.

alfredjp

Technical User
Joined
Jul 3, 2002
Messages
58
Location
JP
just out of curiousity, can anyone show me/teach me on how to write a QUERY that would check if there are ANY CURRENTLY executing jobs?

thank you very much.
 
Don't think there's any entrty made when a job starts.
You can look at master..sysprocesses but it won't tell you what is a job.
You can include a dummy entry as the first step of a job and look for this in sysjobhistory.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top