Schedule a job to generate a script

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  June 24, 2010 at 10:36 am

  #236821

  We can generate a script for an object in SSMS manually. Is there any way to do it in a scheduled job?

  Any input will be greatly appreciated.

• Steve Cullen

  SSCertifiable

  Points: 5598

  More actions

  June 24, 2010 at 10:44 am

  #1184607

  You would need to generate the script from metadata. It's pretty easy though, depending on what you're trying to script.

  Converting oxygen into carbon dioxide, since 1955.