Submitting Control-m jog through an Oracle trigger

Post Reply
User avatar
aruth
Nouveau
Nouveau
Posts: 4
Joined: 14 Nov 2008 12:00

Submitting Control-m jog through an Oracle trigger

Post by aruth » 15 Nov 2008 12:02

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

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Post by fyot » 15 Nov 2008 9:07

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

User avatar
aruth
Nouveau
Nouveau
Posts: 4
Joined: 14 Nov 2008 12:00

Using Oracle trigger to call API

Post by aruth » 17 Nov 2008 3:23

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.

User avatar
mauriziog
Nouveau
Nouveau
Posts: 807
Joined: 08 Jun 2007 12:00
Location: Varese - Italy
Contact:

Post by mauriziog » 17 Nov 2008 4:21

You can run a shell at the end of the oracle job.

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

Post Reply