November 3, 2003 at 10:35 am
Hi
Does anybody have any scripts to check if an agent job is still running?
i.e
if job is running
do this
else
do this
thanks
November 3, 2003 at 6:14 pm
No script handy, but you could query sysprocesses, or check sysjobhistory in MSDB.
Andy
November 4, 2003 at 2:24 am
Thanks Andy
I was being lazy really, didn't fancy reinventing the wheel if anybody else had already got a script! I think sp_help_job will also help me.
November 6, 2003 at 5:18 am
No script but this stored procedure will provide a list of all running jobs:
msdb.dbo.sp_get_composite_job_info NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply