Monday, March 12, 2012

im a newbe. please help

i'm turning up a replicated SQL SVR database environment on dedicated hardware. other than the instance name, all database will be exactly the same. my question is, is it possible to export, or copy scheduled jobs from the first database environment to the newly created environment? i'd like to avoid having to recreate all of them, if possible.Generate SQL script from existing job, then execute the script in your new environment.|||Or use DTS (Data transformation services Wizard) , local packages, select the transfer job task then follow the wizard.

No comments:

Post a Comment