You can use the Automation Designer in Toad to schedule many, many tasks within Toad. Please see the online Help within the tool, and there is a video describing the process here:
For any of the windows that support command line execution:
-
Go to the window and set your options as if you were going to run the window now.
-
Click the "save settings to file" button (floppy disk icon).
-
Open up the file you just made with Notepad. There are directions in it on how to do the rest:
-
The directions show how to call TOAD from the command line with this options file.
-
If you want TOAD to close after it runs, uncomment "CloseTOAD"
-
Depending on which window this is, there may be other things you need to specify, and they are described in this file.
-
If you want this to run nightly, you can make a batch file with the appropriate command and then schedule it with your Windows scheduler.
-
Start the discussion at forums.toadworld.com