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!

Restart a "Stopped" job

User_0CAAMJul 25 2019 — edited Jul 30 2019

Hello,

Following an unplanned server reboot, an Oracle job is now in Stopped status. In additional_info it says REASON="ORA-01014: ORACLE shutdown in progress".

The job is FILE_SIZE_UPD and it's supposed to run every 5 minutes. The next_run_date Indeed reflects that and every time I check the scheduler table the job is planned to run in the next few minutes. But it doesn't run.

I tried disabling/enabling the job with dbms_scheduler.disable/enable. Nothing changed.

I tried executing the job with dbms_scheduler.run_job with both use_current_session true and false. Nothing changed.

This post has been answered by User_0CAAM on Jul 30 2019

Jump to Answer

Added on Jul 25 2019

#database-key-features, #scheduler

10 comments

9,720 views