Oracle Job not running in schedule task

Oracle Job not running AUTO in schedule task
=============================

select value from v$parameter where name='job_queue_processes';


------------------If the value is 0 job will not run auto --------------------------

If this is the problem you can increase the parameter using
SQL> alter system set job_queue_processes= xxxx;


Comments

Popular posts from this blog

SQL Tuning Task Creation ORA-13780: SQL statement does not exist.

Shareplex some commands

ORA-1092 : opitsk aborting process