In Toad, is there a way to generate a table DDL script automatically, and schedule it to run?
1. In Utilities | Automation Designer, create a new app (toolbar or on the left panel).
2. On the right add an Export DDL action ( Export tab | Export DDL | double click), and configure it to export any DDL that's required (right click | Properties or double click).
3. The action can then be scheduled via a right-click on the action (on the right) and choose to Schedule or select the app on the left and right click | Schedule.
Here is some further information about using Task Automation in Toad in Toad World's blog.
Check Toad's Help file | Contents | Manage Projects | Automate Tasks and Processes for details about the all Automation Designer features.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center