April 13, 2004 at 12:30 pm
I am running SQL2K and am trying to query the sysjobhistory table for run_status = 4 to retrieve jobs in progress. I have also tried
exec msdb..sp_help_jobhistory @run_status = 4. My jobs 'in progress' do not appear until complete or cancelled.
Is there a way to get this to work?
April 13, 2004 at 12:40 pm
Sorry, disregard my question, I just looked at sp_help_job procedure. This should give me what I need.
January 9, 2007 at 12:19 pm
actually... i am running across the same thing. what other way
is there to see which jobs are currently running? besides
looking at Management Studio, or EM of course.
i'm having some jobs check the status of running jobs, and i
at first had them looking at the run_status, but thats not
accurate cause even when the jobs are running it does not reflect
the status at all.
where else can i look?
_________________________
January 9, 2007 at 1:14 pm
neotokyo; Follow sqldba's advice. Check sp_help_job, and use current_execution_status. Not jobactivity and run_status. Jobactivity is updated after each job step.
Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply