全部博文
-
编辑 删除
删除oracle Job
1.删除所有用户的JOB begin for v in(select job from user_jobs) loop dbms_job.remove(v.job); end loop; commit; end; 2.删除指定用户的JOB define USER=&1 begin 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; co
