i'm a newbe. please help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • medmonds
    New Member
    • Aug 2006
    • 1

    i'm 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.
  • AJ2
    New Member
    • Aug 2006
    • 6

    #2
    Generate SQL script from existing job, then execute the script in your new environment.

    Comment

    • Phil1234
      New Member
      • Aug 2006
      • 5

      #3
      Or use DTS (Data transformation services Wizard) , local packages, select the transfer job task then follow the wizard.

      Comment

      Working...