February 24, 2006 at 1:53 pm
What is the best/fastest way to copy multiple Agent Jobs from one server to another?
Thanks...Nali
February 24, 2006 at 2:10 pm
Do you want all the jobs? If so right click on jobs (under management in EM) and generate script.
If you want only a few of them, then click on the individual job and then generate script.
You could also backup msdb and restore on the target server, this option brings all jobs, alerts, operators, dts packages onto the new server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy