PL/SQL (MOSC)

MOSC Banner

One off DBMS_JOB in 19c does not retry on failure

in PL/SQL (MOSC) 3 commentsAnswered

I understand that DBMS_JOB is deprecated in 19c, but our current code uses it and relies on it's transactional nature. We run it without an interval so it is a one off job and we also rely on it to retry if it fails. So for example if we run: (test borrowed from Connor McDonald)

DECLARE
         j INT;
BEGIN
  DBMS_JOB.SUBMIT(j,'declare x int; begin x := 1/0; end;',SYSDATE);
END;

Note we have no interval defined. Once we commit in 12c this runs, fails and tries again with an increasing interval up to a max of 16 times. In 19c it runs, fails and the job disappears from user_jobs and user_scheduler_jobs

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center