hostname oracle ~ > ps -ef |grep cjq |grep DB1
Check the alert log for errors:
SQL> show parameter backg;
Restarting Job Queue Process (CJQ) which is used for the job scheduler.NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle_home/home/dba/oracle/a
dmin/DB1/bdump
SQL> ALTER SYSTEM SET job_queue_processes=0 SCOPE=BOTH;
SQL> ALTER SYSTEM SET job_queue_processes=10 SCOPE=BOTH;
From alert logs:
Tue May 22 00:30:20 2012
ALTER SYSTEM SET job_queue_processes=0 SCOPE=BOTH;
Tue May 22 00:31:39 2012
Restarting dead background process CJQ0
Tue May 22 00:31:39 2012
ALTER SYSTEM SET job_queue_processes=10 SCOPE=BOTH;
CJQ0 started with pid=14, OS id=5936
Verify that CJQ process is now running:
calbe4 oracle ~ > ps -ef |grep cjq |grep DB1
oracle 5936 1 0 00:31:40 ? 0:01 ora_cjq0_DB1
Validate that dba_jobs are running as scheduled.
SQL> select * from dba_jobs_running;
SQL>
set lines 250
col schema_user for a14
col what for a50
col interval for a22
col "Last Run" for a10
col last_sec for a8
col "Next Run" for a10
col IS_BROKEN for a6 heading "Is|Broken"
SELECT job,
schema_user,
what,
interval,
TO_CHAR (last_date, 'MM/DD/YYYY HH24:MI:SS') "Last Run",
last_sec,
TO_CHAR (next_date, 'MM/DD/YYYY HH24:MI:SS') "Next Run",
DECODE(BROKEN,'Y','YES','N','NO',' ') IS_BROKEN,
failures "Failures"
FROM dba_jobs
/