CTMS Common Fixes
From Calidus HUB
CTMS Fixes
Scheduler not running
When Scheduler Audit says:
PLS-00302: component 'FIXED_DROP_SCHEDULING' must be declared
The process has not been set up correctly.
Check table AUTO_SCHEDULING_ENGINE and make sure that the PROCEDURE_NAME value is correct.
Jobs not running
If jobs are not scheduling themselves, or rescheduling themselves after they run.
Problem is likely in the database. Check the following:
-- Jobs not running? Check the following:
select logins from v$instance; -- if not allowed, won't run jobs
select value from dba_scheduler_global_attribute where attribute_name='SCHEDULER_DISABLED' -- if TRUE won't run jobs
select value from v$parameter where name='job_queue_processes'; -- if 0 won't run jobs (most common
alter system set job_queue_processes=20; -- Fix to above issue
