Page 1 of 1

Submitting Control-m jog through an Oracle trigger

Posted: 15 Nov 2008 12:02
by aruth
Hello:

I am new to control-m but we were told that with the Enterprise Manager API we can request and submits jobs using the API using an Oracle trigger. We have the java option installed on our Oracle database. Has anyone done this before and if so, can you provide any information on how to go about it? I am able to load java classes into Oracle and execute them but I am not sure how to invoke the API java classes that came with the API through Oracle.

Thanks,

Al Ruth

Posted: 15 Nov 2008 9:07
by fyot
Hi

No need to use API. You can use

CONTROL-M Business Processing Application Suite
or
CONTROL-M/Control Module for Oracle E-Business Suite

Using Oracle trigger to call API

Posted: 17 Nov 2008 3:23
by aruth
We are trying to avoid having to rewrite existing code. Right now we have a table and when a row is inserted into this table, a trigger fires and kicks off an event. Since we need the Oracle trigger to "trigger the event" we were hoping to be able to call the API whenever the trigger fired (bases on a certain situation).

Thanks.

Posted: 17 Nov 2008 4:21
by mauriziog
You can run a shell at the end of the oracle job.

So you can "trigger" all you want...