user_scheduler_jobs failure_count not reset
Hi, we moved from a ORACLE 12C server to 19C.
We used to have lot of jobs running with the old dbms_job package, now we've switch to dbms_scheduler.
My understanding is that when a job runs with failures then the failure_count incremnents.
But when the underlying procedure or mv refresh succeed then the failure_count should reset.
Is that true? If not what the purpose of this column? I ran the DBMS_SCHEDULER.DISABLE and ENABLE on the faulty jobs that reset the failure_count but then failure_count doesn't reset.
So what is the best query to monitor on a daily basis the job's health.