Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

You are here: Automate Tasks > Execute Automation Scripts

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

  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 displays. See Schedule Windows Tasks for more information.
  2. Select scheduling options in the Schedule tab of the task properties dialog.
  3. In the Task tab, click Set password and enter your Windows password.
  4. 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

  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.

 

Related Topics

Automate Tasks

of