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.

Andy

Re: running status for jobs

Hi

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

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




wrote in message
news:1190367292.261350.224760@r29g2000hsg.googlegroups.com.. .
> 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
>