Database Administration (MOSC)

MOSC Banner

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.

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