Need help determining if a job is running

• dereksigler

  Grasshopper

  Points: 24

  More actions

  March 31, 2004 at 12:55 pm

  #152099

  I have a webpage that displays job historys of the jobs on the SQL Server box.  However, I would like to add/highlight any job that is currently running.  

   

  When you look in jobs in Enterprise manager you can see the status is "running" ot "not running."  How/where does SQL Server look to get that?  I can't find it anywhere in SYSJOBS or SYSJOBSHISTORY.

   

  Thanks,

  -derek

   

   

• dereksigler

  Grasshopper

  Points: 24

  More actions

  March 31, 2004 at 1:14 pm

  #501357

  You can find all data needed to create a IsRunning function at this post.

  Sorry to waste space.

  -derek