Hi experts,
I'm using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
I'm doing a POC with dbms_scheduler and I've created 3 simple programs that do a simple insert in a table.
STEP PROGRAM
A prog_1
B prog_2
C prog_3
As I need them to be execute in parallel, I've created this rule:
condition: TRUE
action: START A, B, C
Last step is to create a job to be run once.
My problem is that job keep running forever as there's no CHAIN_END event:
I notice that because I get an error "ORA-27478: job xxx is running" when I try to drop it with:
begin
dbms_scheduler.drop_job('ORACLE_JOB_412');
end;
/
If I set the force=true parameter I can continue.
begin
dbms_scheduler.drop_job('ORACLE_JOB_412', force => TRUE);
end;
/
What am I doing wrong?
Regards,
Jose.