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
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
