Using TSQL to Generate Scripts/Backup Jobs

• willamette

  SSC Enthusiast

  Points: 144

  More actions

  January 5, 2002 at 3:40 am

  #104604

  Hi,

  I am looking for a way to automatically backup jobs that have been created. I see that you can right click in Enterprise Manager and generate a script for all jobs. Does anyone know how to do this through TSQL? I would like to set up a job that calls a stored procedure that will generate this script on a nightly basis. Or, if you have another idea about how to backup jobs, that would be wonderful.

  Thanks!

  ~Willamette

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 5, 2002 at 6:11 am

  #421766

  I just back up msdb and call it done. Not as granular as scripting jobs of course. If you're using appropriate change control I think just a backup is good enough.

  Have not tried, but I wonder if you couldnt get the scripts fairly easily with DMO. Which leads to another question - does SQL Compare by Red-Gate (an advertiser here on the site and one of my fav products) do jobs? Dont think so but will look!

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737905

  More actions

  January 7, 2002 at 10:42 am

  #421827

  Andy, couldn't you use DMO to do this?

  Steve Jones

  steve@dkranch.net