Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Event based job

joelsNov 16 2006 — edited Feb 17 2010
Hi,

I am trying to create an event-based job, I have tried to read the documentation but I still could not understand it very well.
I have 2 job, for example job A and B.

Job B will run after a successful execution of job A. I have execute below command to make job A raise event at successful completion.

BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE('A','raise_events',dbms_scheduler.job_succeeded);
END;
/

Right here I have no idea how to proceed, I tried creating it using EM. But it asked me for Queue name and Agent name.

Can anyone help ?
Appreciate it :)

Thanks
Joel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2010
Added on Nov 16 2006
21 comments
11,123 views