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

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

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

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).

---

Thank you.

I will try that.

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

We are running VC 6.0.4

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.

---

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.

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.

---

I have emailed the code.

All we need is an API which can kick off a VC job from a Oracle Procedure.

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.

---