hello, My DB is 11g When executing this job
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'PR_FACTURA.BKG_COBRAR(JOB);'
,next_date => to_date('01/01/4000 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'null'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
SYS.DBMS_JOB.BROKEN
(job => X,
broken => TRUE);
COMMIT;
END;
/
I am having
08:04:10 Info: Job #171 has been executed. ORA-12011: execution of 1 jobs failed
ORA-06512: en "SYS.DBMS_IJOB", línea 637
ORA-06512: en "SYS.DBMS_JOB", línea 284
ORA-06512: en línea 1