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
- 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.
- Make your modifications or edits to the script.
- Click Test in the Wizard bar to test run the script on the TIC server.
- When you finish editing, click Republish in the Wizard bar. Toad saves your changes and opens the Publishing dialog.
- 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.
- Click Publish in the Publishing dialog to re-publish the script.
- 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
- 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.
- 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).