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.

No comments:

Post a Comment