|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
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 (status not running and status running only). Thanks in advance for your answer. Andy |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
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.googlegr oups.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 (status not > running and status running only). > > Thanks in advance for your answer. > > Andy > |
|
![]() |
| Outils de la discussion | |
|
|