Job Scripting

• Bidec

  SSCommitted

  Points: 1666

  More actions

  August 5, 2002 at 10:03 am

  #58316

  Hello Everyone,

  How do I create a SQL Script of all the jobs in SQL server ?

  I know there is a way to do it in Enterprise Manager, but would like to know if there are any stored procedures/functions/xp's to do this.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  August 5, 2002 at 10:11 am

  #434029

  Not that I know of unless there is one in the script libary here. Try searching.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones