Learn more about Toad for SQL Server
at Quest.com

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

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Automate Tasks > Execute Automation Scripts

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.

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 window displays.
Select scheduling options in the Schedule tab of the task properties window.
After the script executes, to view the script's execution log, select View | Output or select the Log tab in the script's open Automation window.

Note: When 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.