Search found 4 matches
- 30 Jul 2012 10:57
- Forum: General News
- Topic: calling PL/SQL scripts from Control-M
- Replies: 1
- Views: 27923
PL/SQL
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...
- 30 Jul 2012 6:34
- Forum: Job Definition
- Topic: Zip folder using WinZip through control-M
- Replies: 4
- Views: 9689
GNU zip
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
We have this working on production
- 30 Jul 2012 5:53
- Forum: Job Definition
- Topic: Job Documentation
- Replies: 5
- Views: 8541
Wiki
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.
Every job would point to that documentation and users are encouraged to update process documentation.
- 30 Jul 2012 5:49
- Forum: Job Definition
- Topic: Send mail depending on Oracle function output
- Replies: 0
- Views: 26652
Send mail depending on Oracle function output
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...