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