My Oracle application have stopped transferring data to another table.
After doing a bit of troubleshooting,I have narrowed the issue down to the scheduled job PERSON.FIG_TIME_DAILY
The procedure that is called by this job works fine when I run in manually
However, this scheduled job hasn't successfully run in over a day
I tried dropping the job entirely and rebuilding it using the DDL from the same job in my testing environment, but that didn't seem to work.
Unable to run job "PERSON.FIG_TIME_DAILY" scheduler unavailable
From the online research I've done, most users have resolved this problem with some variation of the command
SQL>show parameter job_queue_processes;
the value was default set to 1000
Than i Google out and run the following
SQL>select attribute_name, value
from dba_scheduler_global_attribute
where attribute_name = 'SCHEDULER_DISABLED';
ATTRIBUTE_NAME VALUE
------------------ -----
SCHEDULER_DISABLED TRUE
-- Attribute vanishes when set to false (run as sysdba)
SQL>exec dbms_scheduler.set_scheduler_attribute ( 'SCHEDULER_DISABLED', 'FALSE' );
After this Scheduler started Working
After doing a bit of troubleshooting,I have narrowed the issue down to the scheduled job PERSON.FIG_TIME_DAILY
The procedure that is called by this job works fine when I run in manually
However, this scheduled job hasn't successfully run in over a day
I tried dropping the job entirely and rebuilding it using the DDL from the same job in my testing environment, but that didn't seem to work.
Unable to run job "PERSON.FIG_TIME_DAILY" scheduler unavailable
From the online research I've done, most users have resolved this problem with some variation of the command
SQL>show parameter job_queue_processes;
the value was default set to 1000
Than i Google out and run the following
SQL>select attribute_name, value
from dba_scheduler_global_attribute
where attribute_name = 'SCHEDULER_DISABLED';
ATTRIBUTE_NAME VALUE
------------------ -----
SCHEDULER_DISABLED TRUE
-- Attribute vanishes when set to false (run as sysdba)
SQL>exec dbms_scheduler.set_scheduler_attribute ( 'SCHEDULER_DISABLED', 'FALSE' );
After this Scheduler started Working