Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 19.25 Scheduler generating false JOB_OVER_MAX_DUR alerts

KoopJan 15 2025

Hi all,

In December we upgraded our database from 19.20 to 19.25.

Since the upgrade scheduler jobs have randomly been generating erroneous JOB_OVER_MAX_DUR alerts.

For example, about an hour ago I received a JOB_OVER_MAX_DUR alert for a job that dba_scheduler_jobs showed a run duration of +00 00:00:00.122639 (Well under a second) and a max_run_duration for that job set to +00 00:05:00.000000 (5 minutes).

The alerts come at random times, for random jobs, and we're getting 3-4 a day out of thousands of runs. The only commonality they all seem to be are SUCCEEDED runs with a run duration of under a second, and a max run duration of several minutes.

Anyone else encounter this?

Thanks!

Comments
Post Details
Added on Jan 15 2025
7 comments
227 views