剔除oracle Job

删除oracle Job

1.删除所有用户的JOB begin  for v in(select job from user_jobs) loop    dbms_job.remove(v.job);  end loop;  commit;end;2.删除指定用户的JOBdefine USER=&1begin  for v in(select job from user_jobs where log_user='&USER') loop    dbms_job.remove(v.job);  end loop;  commit;end;3.删除特定内容的JOB begin  for v in(select job from user_jobs where what    in(     'the_what_name;',        )        ) loop    dbms_job.remove(v.job);  end loop;  commit;end;/补充：dba_jobs：LOG_USER         提交任务的用户PRIV_USER        赋予任务权限的用户SCHEMA_USER      对任务作语法分析的用户模式http://blog.chinaunix.net/u1/40226/showart_2269864.htmlJOB始终没有运行问题1.首先确认当前的Job Queue Processes的数目SQL> select name,value from v$parameter where name ='job_queue_processes';2.如果值为0 然后将Job Queue Processes的数目修改为大于0的数SQL> ALTER SYSTEM SET job_queue_processes = 10;