删掉不是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;
