Database name change in Existing jobs

• Muralidaran

  SSC-Addicted

  Points: 475

  More actions

  November 5, 2007 at 1:07 am

  #183597

  Hi all

  I changed my database name from settings to config.

  I need to change the database name in all my SQL jobs.

  How to find and replace?

  Thanks

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  November 5, 2007 at 5:43 am

  #748191

  Create a DROP & CREATE scripts of the jobs and then do the find..replace thing.

  --Ramesh
  

  ---