Skip to content

How to Resolve ORA-27492: unable to run job: scheduler unavailable


Found error ORA-27492 when executed a tuning job.

    (job_name             => 'SYS.SQLTUNE_JOB_61535_2043'
    ,use_current_session  => FALSE);
Error at line 2
ORA-27492: unable to run job "SYS"."SQLTUNE_JOB_61535_2043": scheduler unavailable
ORA-06512: in "SYS.DBMS_ISCHED", line 209
ORA-06512: in "SYS.DBMS_SCHEDULER", line 594
ORA-06512: in line 2

Let's see the number of jobs that the database can run.

SQL> show parameter job_queue_processes;

NAME                                 TYPE
------------------------------------ ---------------------------------
job_queue_processes                  integer

Oh, there's none. Someone turned it off.


The required actions are just like the content of ORA-27492 below.


ORA-27492: unable to run job "string"."string": scheduler unavailable


A job run with current session set to false can not be issued if the scheduler is not active. Check value of job_queue_processes parameter, issue dbms_ijob.set_enabled(true), database is in upgrade/migrade mode, database is in data guard mode, or scheduler attribute SCHEDULER_DISABLED is set to TRUE


Run the job in the current session or activate the scheduler

Let's start some job process for the database.

SQL> alter system set job_queue_processes=100 scope=both;

System altered.

If your job is still not working, you may need to enable scheduler as well.

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

Either way should make it work.

8 thoughts on “How to Resolve ORA-27492: unable to run job: scheduler unavailable”

  1. I get an error when running the “exec dbms_scheduler.set_scheduler_attribute” command on my PDB. I don’t get that same error when running from the CDB, though.
    I still am getting this error when running a JOB using USE_CURRENT_SESSION = ‘FALSE’. I’m gessing this the mode my job would run when automated/scheduled.
    When anyone help?

    1. I don’t know about this, maybe you should perform a datapatch again? Sometimes, the patch level of PDB is different from CDB, I don’t know.

Leave a Reply

Your email address will not be published. Required fields are marked *