DBMS_SCHEDULER-Jobs in database 10.2.0.4 not executed
All current scheduler jobs didn't started suddenly.
It's entries in DBA_SCHEDULER_JOBS were STATE = SCHEDULED and NEXT_RUN_DATE's in the past.
There were no errors, neither in DBA_SCHEDULER_JOB_RUN_DETAILS nor in mails from Job Notification Package or in alertlog!
All the jobs were from JOB_TYPE = STORED_PROCEDURE. The procedures were valid and could be executed with EXECUTE command.
A new created test job didn't run also.
It's entries in DBA_SCHEDULER_JOBS were STATE = SCHEDULED and NEXT_RUN_DATE's in the past.
There were no errors, neither in DBA_SCHEDULER_JOB_RUN_DETAILS nor in mails from Job Notification Package or in alertlog!
All the jobs were from JOB_TYPE = STORED_PROCEDURE. The procedures were valid and could be executed with EXECUTE command.
A new created test job didn't run also.
After an attempt to start such a job instantly from OEM database control (administration/jobs) and update the OEM website
a l l hanging jobs were starting and successfully executed! Since then all things sound like to be in order again ...?
0