I would like to know how to how to know through sql queries if a job
that was processed is still running...
I tried to use msdb..systasks but it doesn't seem to help (status not
running and status running only).
Thanks in advance for your answer.
AndyHi
You could use "master.dbo.xp_sqlagent_enum_jobs"
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL
<Andy.H.Kwok@.gmail.comwrote in message
news:1190367292.261350.224760@.r29g2000hsg.googlegr oups.com...
Quote:
Originally Posted by
Hello all,
>
I would like to know how to how to know through sql queries if a job
that was processed is still running...
>
I tried to use msdb..systasks but it doesn't seem to help (status not
running and status running only).
>
Thanks in advance for your answer.
>
Andy
>
No comments:
Post a Comment