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.
Control-M for Database - Variable value as an exit code
-
- Nouveau
- Posts: 1
- Joined: 30 Nov 2015 1:56
- Location: Brazil
Re: Control-M for Database - Variable value as an exit code
Hi Juliano
You can set up your stored proc to have input and output parameters... and in the job definition GUI screen, set your variables, under the 'Variable' column.
The output of the stored proc, will be stored in that variable name that you give it.
You can then use that variable name in an ON statement to perform further actions depending on the result.
I've attached a screen shot, as an example, hopefully it has uploaded and can be seen in this post.
hope that helps...
regards
Sharon Chu
You can set up your stored proc to have input and output parameters... and in the job definition GUI screen, set your variables, under the 'Variable' column.
The output of the stored proc, will be stored in that variable name that you give it.
You can then use that variable name in an ON statement to perform further actions depending on the result.
I've attached a screen shot, as an example, hopefully it has uploaded and can be seen in this post.
hope that helps...
regards
Sharon Chu
- Attachments
-
- exampl_screenshot_DB_job_def
- screenshot_DB_job_def.png (40.1 KiB) Viewed 7793 times
- exampl_screenshot_DB_job_def
- screenshot_DB_job_def.png (40.1 KiB) Viewed 7793 times