How to query run status of a currently running job?

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  February 25, 2008 at 2:05 pm

  #76909

  I'm having a bit of a problem determining if a job in question is currently running due to the job being one step and taking 4+ hours to run. I created a wrapper process to monitor the job, but using sysjobhistory, the entry is not made until the step has completed.

  I came across this article: http://www.sqlservercentral.com/articles/Administering/howtofindthatjobisrunning/2071/ and I'm curious to as if anyone is aware of any easier way to accomplish this?

  Thanks

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 26, 2008 at 12:33 pm

  #782188

  How about

  sp_who2 active

  SELECT * FROM master..sysprocesses

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  February 26, 2008 at 12:34 pm

  #782189

  Forgot about this topic ...

  I found what I was looking for in xp_sqlagent_enum_jobs

  Thanks though

• nikhil.satam

  SSC Journeyman

  Points: 77

  More actions

  July 25, 2008 at 7:12 am

  #848353

  CAN YOU TELL ME

  HOW TO USE: xp_sqlagent_enum_jobs

  WHAT ARE THE RESULTS FETCHED BY IT?

  THANKS,

  NIK

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  July 27, 2008 at 8:24 pm

  #848937

  You may try the command below,

  sp_help_job

  For more information about XP_SQLAGENT_ENUM_JOBS, the following link may help.

  http://www.siccolo.com/Articles/SQLScripts/how-to-create-sql-to-sql-job-execution-status.html