oracle job不运行 解决方案

1) Instance in RESTRICTED SESSIONS mode?
　　Check if the instance is in restricted sessions mode:
　　select instance_name,logins from v$instance;
　　If logins=RESTRICTED, then:
　　alter system disable restricted session;
　　^-- Checked!
　　2) JOB_QUEUE_PROCESSES=0
　　Make sure that job_queue_processes is > 0
　　show parameter job_queue_processes
　　^-- Checked!
　　3) _SYSTEM_TRIG_ENABLED=FALSE
　　Check if _system_enabled_trigger=false
　　col parameter format a25
　　col value format a15
　　select a.ksppinm parameter,b.ksppstvl value from x$ksppi a,x$ksppcv b
　　Where a.indx=b.indx and ksppinm=’_system_trig_enabled’;
　　^-- Checked!
　　4) Is the job BROKEN?
　　select job,broken from dba_jobs where job=;
　　If broken, then check the alert log and trace files to diagnose the issue.
　　^-- Checked! The job is not broken.