Job not Running

18 sec read

If a simple run-once job doesn’t run, you can try restarting the scheduler as follows.

SQL> exec dbms_scheduler.set_scheduler_attribute(‘SCHEDULER_DISABLED’, ‘TRUE’);
SQL> alter system set job_queue_processes=0;
SQL> exec dbms_ijob.set_enabled(FALSE);
SQL>
SQL> alter system flush shared_pool;
SQL> alter system flush shared_pool;
SQL>
SQL> exec dbms_ijob.set_enabled(TRUE);
SQL> alter system set job_queue_processes=99;
SQL> exec dbms_scheduler.set_scheduler_attribute(‘SCHEDULER_DISABLED’, ‘FALSE’);

 

Oracle Password Expired

dadin
17 sec read

Generate Insert Script

dadin
2 min read