EXECUTE sp_get_composite_job_info @job_id = 'B74856BF-3326-4B9F-B3A6-B1D182E1F300', @execution_status = 1
IF @@rowcount = 1
PRINT 'job running'
else print 'nope, not'
Monday, March 29, 2010
[Jobs] Quick & Dirty - is the job running?
Needed a simple piece of code to tell me if a job was running or not. Several ways to do it, but this is the simplest and probably dirtiest.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment