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;


No comments:

Post a Comment

Common Oracle Clusterware crsctl commands

  Oracle Clusterware crsctl commands: # Check cluster status crsctl check crs crsctl check cluster # Cluster resources crsctl status reso...