Control-M for Database - Variable value as an exit code
Posted: 30 Nov 2015 2:28
Hi all.
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.
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.
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.
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.