question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked TomPhillips-1744 answered

How to copy more than 50 sql agent jobs

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.