ORA-27492: unable to run job APPS.TEST_UPDATE: scheduler unavailable

I have an issue where the scheduler jobs were not running automatically even when they are scheduled correctly.

I have tried to enable and disable the job but still the issue existed.

Error:

SQL> exec dbms_scheduler.run_job(job_name => '"APPS"."TEST_UPDATE"', USE_CURRENT_SESSION => FALSE);


Failed to process SQL command
- ORA-27492: unable to run job "APPS"."TEST_UPDATE": scheduler unavailable
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 2

Solution:

1) Make sure below parameter is set to non zero value and sufficient enough to run the jobs.

show parameter  job_queue_processes;

alter system set job_queue_processes=100;

2)  Check the Scheduler is disabled in database.

SQL> select attribute_name,  value
from dba_scheduler_global_attribute
where attribute_name = 'SCHEDULER_DISABLED';  2    3  

ATTRIBUTE_NAME
---------------
VALUE
-------
SCHEDULER_DISABLED
TRUE


3) Enable the Scheduler

SQL> exec dbms_scheduler.set_scheduler_attribute ( 'SCHEDULER_DISABLED', 'FALSE' );

PL/SQL procedure successfully completed.

4) Validate the scheduler should not be seen as disabled.

SQL> select attribute_name,  value
from dba_scheduler_global_attribute
where attribute_name = 'SCHEDULER_DISABLED';  2    3  

no rows selected

5) Monitor the jobs and they should run automatically based on the schedules


If you like please follow and comment