List of SQL Server Jobs

• SQLEE

  Ten Centuries

  Points: 1077

  More actions

  April 2, 2008 at 11:37 am

  #120906

  I would like to be able to run a query that will extract all sql server jobs on a certain server with all the job other details. Anyone?

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  April 2, 2008 at 11:50 am

  #797445

  You can query the msdb sysjob* tables to get this information.

• SQLEE

  Ten Centuries

  Points: 1077

  More actions

  April 2, 2008 at 11:55 am

  #797448

  Thanks Mike, I knew it is somewhere in the msdb.