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.
When you schedule a script in Toad, the Job Manager creates a Windows scheduling task. Scheduled scripts run in batch mode. If using another scheduling application, specify "-batch=true" in the command. This executes the script in non-visual (batch) mode. See the procedure below.
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.
To schedule an automation script
Note: To run a scheduled script against a password-protected database, the password must be saved in the Connection Properties dialog.
To execute a script in batch mode
To start Toad and execute a script in batch mode (non-visual mode), enter the following command and arguments:
<path to the toad.exe application> -batch=true “<path to Automation script>”
C:\Program Files\Quest Software\Toad for SQL Server 7.0\toad.exe -batch=true "<path\scriptfilename.tas>"