1

I created a SQL Server job on the dev server with name Job_Test. Now my team wants me to create a new job on dev with name Job_Dev and move Job_Test to the test server.

Is there a way to just transfer Job_Test to the test server without having to create a new job on the test server using SQL script?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
veda
  • 33
  • 3
  • 3
    Right click the job in SSMS, click Script as CREATE to query window, switch the window's connection to the other server and run the script – Charlieface Dec 31 '21 at 14:58
  • Learn to do EVERYTHING via tsql. Then you never have problems moving things or modifying things. And now you need to add this to your disaster recovery plan. You DO have one of those, right? – SMor Dec 31 '21 at 15:14

1 Answers1

6

You can generate script from your job in any server then run it on test server.As following

enter image description here Here

masoud rafiee
  • 427
  • 3
  • 9