API to submit VC Jobs for a Oracle Procedure - VisualCron - Forum

Community forum

Sridhar Ramaswamy
2016-09-02T14:36:50Z
Hi,

I have a VC Job that runs MON-FRI @ 2:00 AM. This job sends an email.

I need this job to be executed from a oracle procedure after the procedure is completed.

is there an API or any other method to do this?

Any help is much appreciated.

Sridhar
thomas
2016-09-02T15:31:03Z
It may be possible in som very cumbersome way, but I would try to avoid this way of running things

If the procedure is triggered from some environment , like for example VC, then the next VC job should be triggered by this environment after the completion of the proc. So everything i triggered from the same place. Then you avoid having jobs that trigger jobs that trigger jobs and so on.

Is this procedure scheduled to run on time on the database itself maybe? You could have the procedure write to some LogTable you create, and then have a VC trigger that looks for this entry.

Thomas





Sridhar Ramaswamy
2016-09-02T15:37:14Z
We are going to use a Log table to track the progress.
The parent process runs at 12:00 AM and it probably takes 30 mins to complete. We want to execute the VC job after that.

They also have the option of running it manually at any time of the day so we cannot have the VC job running 24 hrs a day checking the Log table.

Sridhar
Support
2016-09-03T10:27:26Z
You can probably use the SQL event Trigger in VC for this. It lets you create a query that can match the result of something (like whatever has happened when your stored procedure has run).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sridhar Ramaswamy
2016-09-03T12:40:32Z
Thank you.

I will try that.
Sridhar Ramaswamy
2016-09-06T17:29:21Z
Our VC application does not have the SQL Event in the list? How do we add this?

We are running VC 6.0.4
Support
2016-09-06T18:03:51Z
Originally Posted by: Sridhar Ramaswamy 

Our VC application does not have the SQL Event in the list? How do we add this?

We are running VC 6.0.4



You need to upgrade to the latest.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sridhar Ramaswamy
2016-09-07T14:23:59Z
Thanks.

The SQL Event is a polling event i.e. it is has to run 24 Hrs a day right. We do not want to poll the table all the time.

The user will probably run the process manually once or twice a month. So we need the ability to kick off the VC job once the User initiates the process in the Oracle DB.
Support
2016-09-07T14:44:39Z
Hi Sridhar,

to help you in the future we need to connect your account to an existing customer. Can you please mail your activation code to sales@visualcron.com - you can get it through Server tab->License->Copy activation code to clipboard.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sridhar Ramaswamy
2016-09-07T15:21:16Z
I have emailed the code.

All we need is an API which can kick off a VC job from a Oracle Procedure.
Support
2016-09-09T08:32:53Z
So, I can see the following options:

1. you use SQL Trigger in VC to check for a specific value in database
2. you check if Oracle have any feature to interact with other application like starting a process, writing to a file etc. If yes, VC can react on that.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top