Cannot query jobs in progress

  • 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?

  • Sorry, disregard my question, I just looked at sp_help_job procedure.  This should give me what I need.

  • 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?

    _________________________

  • 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