You can share Automation scripts with other Toad Data Point users by publishing the scripts to a Toad Intelligence Central (TIC) server. Running your scheduled Automation scripts on the Intelligence Central server is also a great way to offload work from your local computer.
For an in-depth look at how script publishing works in Toad, see About Publishing Automation Scripts.
To see if you need to prepare your script for publishing, see Prepare to Publish Automation Scripts.
Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.
To publish a script to Toad Intelligence Central
|Use relative path to find files must be deselected||
In the TIC environment, Toad cannot successfully run a script that uses relative file paths.
Publishing is designed to be used with scripts that include only network-stored input and output files (with the exception of files that Toad embeds). If necessary, please modify your script to use input and output files that are stored in a network location before publishing
|Embed files into Automation script must be selected||Toad embeds into the script any Toad input files, linked SQL files, and other Automation scripts. See How Toad Manages Input and Output Files for a complete list of files.|
Toad modifies a temporary version of the script (scriptname@datetimestamp) and loads it into the Automation window while the Publishing dialog displays. Your original script remains untouched.
If you click No, you can modify the script settings yourself (click the Settings icon in the script design pane) and then publish.
After you click Yes (or if the script did not require modifications), the Publish to Intelligence Central dialog opens. Select a destination server and a folder. Then enter a name to display in the Object Explorer.
Note: The name must be unique among Automation scripts. No two scripts in the same Intelligence Central instance can have the same name (regardless of folder).
Specify user to execute automation script—Select to specify a Windows user account. Then enter account credentials. You can change the account later using the Script Manger (see Manage Automation Scripts in Intelligence Central).
Tip: Click to view the password, allowing you to confirm it was entered correctly.
Use default user to execute automation script—Select to use the default user account, which is the account under which the Toad Intelligence Central App Server is currently running.
To limit the script run time, enter a maximum run time in Script execution limit.
After specifying options, click Publish in the Publish to Intelligence Central dialog to publish your script.
If you selected to test run the script, Toad immediately publishes the script, tests the script's database and FTP connections on the TIC server, and then test runs the script (on the TIC server).
It is recommended that you test run your script when publishing to uncover any issues such as missing input files or connections that are not properly set up on the TIC server.
When the test run is finished, a success (or error) message displays. Click Yes in the message window to view the execution log. This log details script execution on the TIC server. Check the log for any errors, such as missing input files or connection issues. Troubleshoot Scripts on Intelligence Central
To view the execution log at a later time, right-click a published script in the Object Explorer and select View Details. Then select the Logs tab.
To rename an Automation script file, do so through Toad (File | Save File As), not through Windows Explorer. Renaming a script file using Toad ensures that log files are created correctly and properly synced with their scripts.