I'm trying to schedule a job using cm for database which calls an oracle function, but whenever I run it, the job always get an "Ended OK" status in return. The thing is, aparently this function doesn't use a raise application error
to exit with an appropriate return code... just return a char value, so I need to load the value returned by the function into a variable.
File comment: Job Settings
Function_Screen.png [ 9.2 KiB | Viewed 5146 times ]
What I'm trying to do is use this variable, where I have loaded the value returned, as an exit code for the job. However, there's no option to do so on the "on/do actions"... I even tried using the statement/code option, but it didn't work as well.
Any help about this?
Control-M version: 8
CM for Database version: 7
Thanks in advance.