I want to restore all jobs from one server to another. I seem to remember that in SQL 2000 there was an option to script all jobs but it seems that in 2005 you have to script them 1 at a time. Is there a more efficient way than scripting each job and then executing each script individually?
Thanks,
-Dave
you still can. just open the 'summary' window and go to jobs. highlight all the jobs and generate the script.
No comments:
Post a Comment