A simple query to list all running SQL jobs.

• Mehernosh

  SSC Eights!

  Points: 826

  More actions

  September 5, 2011 at 8:28 am

  #390341

  EXEC MSDB.DBO.SP_GET_COMPOSITE_JOB_INFO NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL

  Assumption made: EXEC sp_configure 'Agent XPs' has been set. 🙂

  Mehernosh.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  September 5, 2011 at 11:18 am

  #1377115

  ? :w00t:

  ---

  
  
  My blog