To move SQL Server Agent Jobs from one server to another

Question

I just need some advise or solution please.

I have SQL Server SQL1 and it has more than 50 agent jobs. I have to move those jobs to a new SQL Server called SQL2.

What is the best, easiest and most secure way to do so? Is there any copy and paste way?

Thanks in advance

https://www.sqlshack.com/move-sql-databases-to-a-different-server-using-sql-server-log-shipping/ step by step explained here — Jayasurya Satheesh, Sep 07 '21 at 05:17
[How to move a SQL Agent Job to another Server?](https://dba.stackexchange.com/questions/55278/how-to-move-a-sql-agent-job-to-another-server) — huMpty duMpty, Sep 07 '21 at 15:29

score 6 · Accepted Answer · edited Sep 07 '21 at 15:20

6

2 ways that I know of:

edited Sep 07 '21 at 15:20

Dharman

answered Sep 07 '21 at 15:15

Sharon Rimer

score -1 · Answer 2 · answered Sep 07 '21 at 05:21

-1

you can use management studio, right click on specified job

Script Job as > Create to > ....

answered Sep 07 '21 at 05:21

Faramarz Fayazfar

2 Answers2