sql-serversql-server-agent

To move SQL Server Agent Jobs from one server to another

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

Solution

  • 2 ways that I know of:

    1. Generate Scripts for SQL Server Objects
    2. Scripting all Agent Jobs Using SQL Server Management Studio