Wednesday, March 21, 2012

running status for jobs

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.

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
>

sql

No comments:

Post a Comment