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.set_attribute end date not changing next run_date

user5716448May 30 2018 — edited May 30 2018

Hi,

We have a scheduled job (version 11.2.0.3) and noticed it hadn't ran.

Checked all_scheduler_jobs and discovered end_date was 28th may 2018

Tried below to adjust end date and thought this would cause next_run_date to adjust so would then run again daily as normal but next_run_date still remains 28th may 2018 thought would adjust to

dbms_scheduler.set_attribute (name => 'MIS_ALIST_JOB',attribute => 'end_date',value =>to_date('31/12/4000','DD/MM/YYYY'));

Also had tried y set end_date as null.

Could just drop and recreate but wondered why next_run_date would not just adjust with above.

Thoughts?

Thanks

This post has been answered by SeánMacGC on May 30 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2018

Added on May 30 2018

#general-database-discussions

9 comments

1,057 views