Execute and Schedule Automation Scripts

You can execute automation scripts on demand from the Automation window or the Project Manager. You can also schedule scripts to run on a recurring basis at a specific time. For example, schedule a script that performs long-running tasks to run when database activity is light.

To schedule an automation script

With a script open in Automation, click in the Automation toolbar. A Windows Scheduler task is created for the script and a task properties dialog displays. See Schedule Windows Tasks for more information.
Select scheduling options in the Schedule tab of the task properties dialog.
In the Task tab, click Set password and enter your Windows password.
After the script executes, to view the script's execution log, select the Log tab in the script's open Automation window.

Note: If you view the Toad Event Log in the Output window, all log content moves to that window. As a result, the log is cleared.

To execute a script from the Automation window

Click in the Automation toolbar. The script is compiled and executes immediately.
To view the script's execution log, select the Log tab.
If you want to schedule the script, first resolve any problems that caused activities to fail or disable failed activities. An activity can be disabled from its Activity Info window.

Tip: To execute a script from the Project Manager, right-click the script and select Execute.