Thursday, March 29, 2012

copy jobs from one server to another

How do you copy all jobs from one server to another? Is there a way to do this programatically?
Script the jobs in SQL Management Studio and execute them on the other server. Make sure before you execute them on the target box everything looks good.|||

I suggest using an SSIS package running the Transfer Jobs Task.


As for programmatically, i would think you could do it using SMO but i've never done so.

Hope this helps.

No comments:

Post a Comment