Copying Agent Jobs

  • What is the best/fastest way to copy multiple Agent Jobs from one server to another?

     

    Thanks...Nali

  • 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