How to schedule a script or automate a process in Toad for Oracle in the command line or Windo (4297947)

How to schedule a script or automate a process in Toad for Oracle in the command line or Windows Scheduler.

Toad 8.x versions:
For any of the windows that support command line execution:
1. Open the desired window and set the options as if you were going to run the utility now.

2. Click "save settings to file" button (floppy disk icon).

3. Open the file just created in Notepad. There will be directions listed on how to call Toad and run the options file from a command line. Depending on which window this is, there may be other things you need to specify, and they are described in this file.

4. If you want TOAD to close after it runs, uncomment "CloseTOAD".

5. To run nightly, create a batch file with the appropriate commands, then use the Windows Scheduler to schedule the batch file to run.

For Toad 10.x versions:
1. Make desired changes to DB Health Check reports
2. Select the Save/Load Window Snapshot icon located at the bottom-right corner of the screen.
3. Select Set1 under App dropdown or enter Set1 in this field
4. Enter a desired name in the Name field and hit OK
5. Select Utilities | Automation Designer menu option from main menu on top of the screen
6. Select Set1 from the left-side tree and the saved DB Health Check action will be shown under Import/Export tab
7. Highlight this action name and right-click on it to run it or schedule it to run at a future time