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

Hi

You could use "master.dbo.xp_sqlagent_enum_jobs"
--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL




<Andy.H.Kwok (AT) gmail (DOT) com> wrote