Run a Job Scheduled in Enterprise Manager Oracle

[Osmar Malheiros]

Hi Erman,

  I have a job scheduled in Oracle 11g, when I try execute the job immediatly, I get this error:


java.sql.SQLException: ORA-27492: unable to run job "BIDUSER.READ_XML_FTP": scheduler unavailable ORA-06512: at "SYS.DBMS_ISCHED", line 185 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 2


  Do you know why?


Best Regards

[ErmanArslansOracleBlog]

I think The global dbms scheduler attribute is in disabled status.

Connect as sysdba and use the following query to check;
SELECT o.name, a.* FROM sys.obj$ o, sys.scheduler$_global_attribute a WHERE o.obj# = a.obj# AND BITAND(a.flags,1) != 1;

If the output shows SCHEDULER_DISABLED as TRUE, enable it using the following.;

exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE');
commit;

Then, retry.