Skip to Main Content

SQL & PL/SQL

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!

DBMS_SCHEDULER

835183Oct 20 2011 — edited Oct 20 2011
Hi,

I have a DBMS_Scheduler job that runs fine and gives me the output i need.

The job is called in the following way through a AFTER INSERT OR UPDATE TRIGGER (Trigger is called TRG_RPT)

DBMS_SCHEDULER.ENABLE ('REP_JOB');

DBMS_SCHEDULER.run_job ('REP_JOB',FALSE);

i get the follwing error when try running the job with 1-3 sec gap...

ORA-27478: job "REP_JOB" is running
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at "TRG_RPT", line 31
ORA-04088: error during execution of trigger 'TRG_RPT'


TRG_RPT: its is an pragma autonomous_transaction; trigger


is there any way i can make my job run parallely without waiting for pervious trigger of the run...

I was under assumption that by having false in DBMS_SCHEDULER.run_job ('REP_JOB',FALSE); will help but i think i am wrong..

Please let me know how to overcome this issues.

Thanks
SAMI
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2011
Added on Oct 20 2011
4 comments
535 views