we are using Nolio to automate executions of multiple .sql scripts in ORACLE database. what is the best way to implement it if we have multiple schemas to run on? any useful links or references to show this scenario will be very helpful.
Thanks
This is really dependent on the specific details of the scripts. Some of them are better served by converting into CARA Actions, others can be called using the built-in Oracle script actions, others might need to be executed using plsql at the command line.
Another challenge you might face is capturing and parsing the output from the script's execution for any potential errors.
The best place to ask this question, as well as provide details, would be on the community forum for CARA.
Note, CA Release Automation (CARA) is the current name of the product that was formerly known as Nolio :)