Get errors from running an Oracle scheduler job:
SQL> exec dbms_scheduler.run_job(job_name=>'BATCH_JOB', use_current_session=>false); BEGIN dbms_scheduler.run_job(job_name=>'BATCH_JOB', use_current_session=>false); END; * ERROR at line 1: ORA-02800: Requests timed out ORA-06512: at "SYS.DBMS_ISCHED", line 196 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 1
WORKAROUND
1)check parameter to make sure not zero.
SQL> show parameter job_queue_processes NAME TYPE VALUE -------------------------------- ------------ ------------------ job_queue_processes integer 100
2) Bounce the database due to the bugs.
3) Rerun the job successfully.
SQL> exec dbms_scheduler.run_job(job_name=>'BATCH_JOB', use_current_session=>false); PL/SQL procedure successfully completed.