September 15, 2011 at 2:03 am
Comments posted to this topic are about the item Query to list all running SQL jobs.
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
NigelHow to post questions
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