Skip to Main Content

Database Software

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!

Standby database scheduled jobs disappear after open if job_queue_processes=0

2959535Nov 21 2019 — edited Nov 22 2019

We're running Oracle Enterprise 12.1 on Linux and it appears that if job_queue_processes=0 on the standby database, that the non-sys scheduled jobs go away when the DB is opened.

I've been using job_queue_processes to limit the job execution vs DBMS_SCHEDULER.Set_Scheduler_Attribute('SCHEDULER_DISABLED','TRUE') because I can set the standby differently than the primary.  Has anyone else seen this behavior and is it a bug?

Comments
Post Details
Added on Nov 21 2019
3 comments
807 views