Monday, February 29, 2016

ORA-27492: unable to run job : scheduler unavailable

Check JOB_QUEUE_PROCESSES parameter value.

User was able to execute the job manually by selecting "Use Current Session" option within TOAD. But gets an error ORA-27492 when choosing "Do not use current session" option.

Alter session set job_queue_processes = 10; (based on #of jobs you will be executing simultaneously)

ORA-27492: unable to run job "JOB_NAME": scheduler unavailable
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 2