ORA-27492: unable to run job “KISH”.”MV_MVREMOTE_REFRESH1″: scheduler unavailable

ORA-27492: unable to run job “KISH”.”MV_MVREMOTE_REFRESH1″: scheduler unavailable

Cause: The below error occur during lack of job queue processes or less job queues

kIsH@xHydra<>BEGIN
               DBMS_SCHEDULER.RUN_JOB
               (
                job_name => 'MV_MVREMOTE_REFRESH1',
                USE_CURRENT_SESSION => FALSE
               );
          END;
          /
BEGIN
*
ERROR at line 1:
ORA-27492: unable to run job "KISH"."MV_MVREMOTE_REFRESH1": scheduler unavailable
ORA-06512: at "SYS.DBMS_ISCHED", line 242
ORA-06512: at "SYS.DBMS_SCHEDULER", line 566
ORA-06512: at line 2

Solution:

kIsH@xHydra<>show parameter job_queue

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     0

kIsH@xHydra<>ALTER system set job_queue_processes=20;

System altered.


kIsH@xHydra<>BEGIN
               DBMS_SCHEDULER.RUN_JOB
               (
                job_name => 'MV_MVREMOTE_REFRESH1',
                USE_CURRENT_SESSION => FALSE
               );
          END;
          /  2    3    4    5    6    7    8

PL/SQL procedure successfully completed.