DBMS_SCHEDULER
835183Oct 20 2011 — edited Oct 20 2011Hi,
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