删掉不是SYS用户下的所有JOB

删掉不是SYS用户下的所有JOB

select * from dba_jobs;

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;
/

select * from dba_jobs;

复制