It is currently 22 May 2019 5:30

Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 30 Nov 2015 2:28 

Joined: 30 Nov 2015 1:56
Posts: 1
Location: Brazil
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.

File comment: Job Settings
Function_Screen.png [ 9.2 KiB | Viewed 6344 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.

PostPosted: 11 Jan 2016 6:19 
User avatar

Joined: 22 Sep 2006 12:00
Posts: 27
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...

Sharon Chu

File comment: exampl_screenshot_DB_job_def
screenshot_DB_job_def.png [ 40.1 KiB | Viewed 4003 times ]
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 2 posts ] 

All times are UTC+02:00

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by All Rights Reserved