January 5, 2002 at 3:40 am
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
January 5, 2002 at 6:11 am
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
January 7, 2002 at 10:42 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply