Snowfun

导航

 

BEGIN
 FOR job_id in(select job,log_user,priv_user,schema_user from dba_jobs)
   LOOP
    IF(job_id.log_user not LIKE '%SYS%') THEN
       BEGIN  
          dbms_ijob.remove(job_id.job);
          commit;
        end;
    end if;
  end loop;
end;
  /

posted on 2018-05-10 11:09  Snowfun  阅读(290)  评论(0编辑  收藏  举报