Toad Data Studio Subscription 1.0 - Installation Guide

Edit or Copy Automation Scripts on Intelligence Central

With Toad you can open and edit an Automation script stored on Toad Intelligence Central (TIC) and then re-publish the script back to the same TIC instance. To edit a script, you must have Manage privileges to the script. See Specify Sharing and Manage Privileges for Objects.

You can also copy a currently-published Automation script and save it locally as a new file.

Note:This feature is available in the Toad Data Studio Professional edition only and requires access to a Toad Intelligence Central server.

To edit a published Automation script

1. In the Object Explorer, right-click the script and select Operations | Edit Script or click . The script opens for editing in an Automation design window.
   • If the script contains connections that are not currently defined in your Connection/Navigation Manager, Toad automatically defines those connections for you.
2. Make your modifications or edits to the script.
3. Click Test in the Wizard bar to test run the script on the TIC server.
4. When you finish editing, click Republish in the Wizard bar. Toad saves your changes and opens the Publishing dialog.
5. You can modify those options that are enabled. You cannot change the script name or the destination TIC server. See Publish to Toad Intelligence Central for option descriptions.
6. Click Publish in the Publishing dialog to re-publish the script.
7. If you selected Test run the script after it is published, Toad re-publishes the script, tests the script's database and FTP connections on the TIC server, and then test runs the script.

Tip: While editing, you can click File | Save File As at any time to save a copy of the edited script locally.

To save a copy of a published Automation script

1. In the Object Explorer, right-click the script and select Operations | Copy Script (or select the script and click ). A copy of the script opens in the Automation design window.
   • If the script contains connections that are not currently defined in your Connection/Navigation Manager, Toad automatically defines those connections for you.
2. Click File | Save File As to select a location in which to save the copy.

Note: A copy of a published script is automatically saved in the Application Data directory whenever you open it in the Automation design window (select Help | About to open this directory).

Related Topics

Publish Automation Scripts to Intelligence Central