Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich How to find that job is running? RE: How to find that job is running?
Jeff Hachmann
SSC-Addicted
Points: 438
More actions
October 18, 2005 at 9:03 am
#597955
You could also use the following I got from an earlier article on this site.
msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL
Jeff