Hi ,
I have executed the below code using SQL plus on Oracle 11g database.
DECLARE
JobVar BINARY_INTEGER;
CallProc VARCHAR2(100) := 'BEGIN proc_a2b_cpoy('
||chr(39)||'ADM'||chr(39)||','||chr(39)||'BDM'||chr(39)||','||chr(39)||'A2B'||chr(39)||'); END ;' ;
BEGIN
DBMS_OUTPUT.PUT_LINE(CallProc);
DBMS_JOB.SUBMIT(JobVar, CallProc ); Commit;
END;
The above block faced a exception and hence failed.
But the issue is that the job is getting triggered automatically afer few minutes and ia gaian getting failed becasue of the same exception as of the first time.
When this was happening , the column SYS.USER_JOBS.FAILURES was increasing from 1.
Can you lease let me know hw can we stop the automatically running failed jobs.
Thanks,
Venu