Share via

How to copy more than 50 sql agent jobs

Avyayah 1,291 Reputation points
2021-04-23T08:44:11.403+00:00

What is the easiest way to copy more than 50 sql agent jobs from one sqlserver to another. What is the process of copying all Maintenance plan from one server to another.

SQL Server | Other
0 comments
Accepted answer
  1. Tom Phillips 17,771 Reputation points
    2021-04-23T14:47:57.543+00:00

    I highly recommend against copying maintenance plans between servers. They are SSIS packages which contain connection string, etc which all need to be fixed after the copy.

    It is best to setup new maintenance plans on new servers manually, or don't use maintenance plans at all and use Ola's scripts instead https://ola.hallengren.com/ They are much more flexible.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,441 Reputation points
    2021-04-23T09:16:35.587+00:00
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.