Hello. I know two ways to execute PL/SQL scripts from Control-M: 1. If you are using a Unix-type operating system on your database system, you can create a shell script to launch a sqlplus session and then use the execute comand to run your PL/SQL. Example: sqlplus /nolog connect [$user_name]/[$user...

You can also install GNU Utilities for windows and then send commands. Jobs could be defined as commands and then compress what you need.

We have this working on production

In our organization, we document every job using a Wiki (MediaWiki)

Every job would point to that documentation and users are encouraged to update process documentation.

Hello everybody. I have a defined Oracle function. This function returns "1" or "0" depending on some internal logic. I can capture the function's output to a variable when i execute it directly as a stored procedure, but what i really need is Control-M notify me by email ONLY when the output of the...