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!

DBMS Scheduler job not sending a particular event notification

Kuwali Sarma-OracleSep 30 2022 — edited Sep 30 2022

I have a scheduler job, which is sending out notifications as expected for job_started, job_succeeded, job_completed.
But I have set job_max_duration_parameter to 1 minute 30 seconds, so ideally I should receive a notification if the job runs for over this period. The job is running for 2 minutes, but I am not receiving the email notification. Can someone help me figure it out?
I have posted the code for the job in the next comment.

This post has been answered by GregV on Oct 6 2022
Jump to Answer
Comments
Post Details
Added on Sep 30 2022
7 comments
266 views