Re: Run a Job Scheduled in Enterprise Manager Oracle

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Run-a-Job-Scheduled-in-Enterprise-Manager-Oracle-tp599p602.html

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.