How to make 19C DBMS_JOB restart on failure

Hi,

I'm still using dbms_job package with Oracle 19c, because I want a transactional job (i.e. the trigger create a job. If the transaction is rollbacked the job musn't exist), and I don't know how to do that with dbms_scheduler.

Sometimes, my job finish with an error. I know it can occurs, and in that case with database 12g the job is started again until it works or have 16 failures

But I've just seen that with a 19g database, when the job fails, it disappears from the job queue. It can create bugs in my app.

Here's a test case :