Showing posts with label area. Show all posts
Showing posts with label area. Show all posts

Thursday, March 29, 2012

copy jobs from one server to another

I've done this before and just can't seem to remember how I did it. Basically we're creating a staging area and I've used restore to copy all the databases to the new server. Now i just need to copy the jobs over. Is there a way to do this using sql code?

Using SSMS (or EM), you can right-click on the job and script them out.

You can also use DTS (SQL 2000) or SSIS (SQL 2005) to transfer all of the jobs.