I am new to Automation Designer, and I am tasked with setting up a Continuous Integration service that keys off Jenkins deployment via a Git source repository which then makes a command line call to execute a dynamic build on a windows server. Within the Automation Designer App it first connects to the respective DB depending on which branch the code was deployed to… i.e. Develop branch will deploy to all 3 Dev servers… Master branch will deploy to our SIT servers. Shell commands are executed to Telnet to the proper server and perform Git checkouts to get the most recent source code to be deployed. Then within the same “Connection Iterator” it performs a series of “Folder Iterator” operations to deploy “MISC Scripts” first, then “Triggers”, “Packages” and so forth until the build is complete, then a series of validation scripts are executed with a call to zip up all the log files and send them as an attachment via email to our teams distribution list. For the most part everything is pretty much working fine except for each “Folder Iterator” it appears to make a new connection every time and loses the SET commands that were executed at the beginning of the process. I have attempted to create a new “Execute Script” process and even hard coded the SET commands as “Script Source” = “Text”, however that script seems to drop into a separate session as well. Is there any way to globalize the SET commands for all scripts executed from every single Folder Iterator? I don’t want to have to update hundreds of scripts with the prefixed SET commands… please help!
PS. I also don’t want to hard code any script file names, we want a fully automated solution to give us the flexibility to check in new program files to be deployed without having to go back and modify the deployment process.
Does TOAD have a default SET configuration similar to how SQL*Plus used to do it?