Monitoring DBA_SCHEDULER_JOBS
I’ve come across a problem when using our monitoring scripts, with the adoption of Apex 23.1, and what it’s doing to DBA_Scheduler. These scripts are sql code called from ksh scripts. My coding skills aren’t up to it, and I’ve been trying to get a solution for a few days and not getting very far. The database is 19.20
The issue is that there is a new job in 23.1 (ORACLE_APEX_BG_PROCESSES), that runs every couple of minutes, but if the database is in the state of closing, the job status is recorded as “STOPPED” and adds to the failure_count in DBA_SCHEDULER jobs. When the database is restarted, the job kicks in again and completes successfully.