|
Posted by Jack Vamvas on 09/21/07 14:05
Hi
You could use "master.dbo.xp_sqlagent_enum_jobs"
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL
<Andy.H.Kwok@gmail.com> 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
>
Navigation:
[Reply to this message]
|