-1

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Salman81
  • 95
  • 1
  • 8

2 Answers2

6

2 ways that I know of:

  1. Generate Scripts for SQL Server Objects
  2. Scripting all Agent Jobs Using SQL Server Management Studio
Dharman
  • 30,962
  • 25
  • 85
  • 135
Sharon Rimer
  • 138
  • 1
  • 7
-1

you can use management studio, right click on specified job

Script Job as > Create to > ....