SQL Job Information

• Uncle Boris

  SSC Enthusiast

  Points: 191

  More actions

  April 21, 2008 at 9:04 pm

  #121478

  Hi, would anybody know where I could source a script to return my SQL Job information?

  I have one for SQL 2000 that returns one row for every job with info like enabled, frequency, next run, avg time, max time, run time etc etc

  Common for sql 2000 but I can not seem to find one for SQL 2005 because the 2000 one does not work.

  Maybe a custom report could do the trick?

  Thanks for any help.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 21, 2008 at 9:41 pm

  #805275

  This? http://www.sqlservercentral.com/scripts/Maintenance+and+Management/62222/

  Search "Job Information" here on the site and then limit by scripts.