CTMS Common Fixes: Difference between revisions
From Calidus HUB
(Initial Creation) |
(Updated) |
||
| Line 11: | Line 11: | ||
Check table AUTO_SCHEDULING_ENGINE and make sure that the PROCEDURE_NAME value is correct. | 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: | |||
<code>-- Jobs not running? Check the following:</code> | |||
<code>select logins from v$instance; -- if not allowed, won't run jobs</code> | |||
<code>select value from dba_scheduler_global_attribute where attribute_name='SCHEDULER_DISABLED' -- if TRUE won't run jobs</code> | |||
<code>select value from v$parameter where name='job_queue_processes'; -- if 0 won't run jobs (most common</code> | |||
<code>alter system set job_queue_processes=20; -- Fix to above issue</code> | |||
[[Category:CTMS]] | [[Category:CTMS]] | ||
Latest revision as of 15:57, 27 August 2025
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
