Mehernosh
SSC Eights!
Points: 826
More actions
September 15, 2011 at 2:03 am
#257356
Comments posted to this topic are about the item Query to list all running SQL jobs.
Mehernosh.
nigel.
SSChampion
Points: 11636
September 15, 2011 at 7:51 am
#1381973
You don't need all those NULLs, just:
EXEC msdb.dbo.sp_get_composite_job_info @execution_status=1
NigelHow to post questions
jackdonnell-684036
Old Hand
Points: 315
October 4, 2011 at 11:41 pm
#1390501
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.
akljfhnlaflkj
SSC Guru
Points: 76202
May 12, 2016 at 7:06 am
#1878561
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