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

View running queries in postgresql

 View running queries in postgreSQL: SELECT * FROM pg_stat_activity;