The action is okay for running simple statements. Once you start getting into more advanced scripts (for example: nested begin blocks, calling procedures, etc..) then it is recommended to execute your .sql scripts using the "Run Command Line" action configured to call the scripting with your preferred sql client.
The following points are worth nothing while using third party sql clients (for example: sqlplus) to execute your sql scripts via CARA:
- Many of these sql clients (for example: sqlplus) have the ability to execute sql scripts against remote servers. So you don't need an agent on every db server where you want to run your sql scripts.
- It is recommended to create a Server Type that represents the sql client system where you will run the scripts.