September 15, 2011 at 2:03 am
Comments posted to this topic are about the item Query to list all running SQL jobs.
Mehernosh.
September 15, 2011 at 7:51 am
You don't need all those NULLs, just:
EXEC msdb.dbo.sp_get_composite_job_info @execution_status=1
October 4, 2011 at 11:41 pm
Another option would be to use : exec msdb..sp_help_job @execution_status = 1. The information is a bit verbose and does not give you the current job step.
May 12, 2016 at 7:06 am
Thanks for the script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy