Toad for SQL Server 8.1 - Installation Guide

Execute 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.  

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

1. Click in the Automation toolbar. The script is compiled and executes immediately.

2. To view the script's execution log, select the Log tab.

3. 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

1. 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 opens.
2. To schedule the script, select the Triggers tab. Select the scheduling trigger for this task and click Edit.
3. In the Edit Trigger dialog, specify scheduling details. Click OK to save your changes and close the dialog.
4. To run the script when you are not logged on, in the General tab select Run whether user is logged on or not. Then enter your Windows credentials when prompted.
5. When finished, click OK to save your changes and close the task properties dialog. For detailed information about the task properties dialog, see Schedule Windows Tasks.

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>”

  For example:

  C:\Program Files\Quest Software\Toad for SQL Server 7.4.1\toad.exe -batch=true "<path\scriptfilename.tas>"

Related Topics

Automate Tasks