begin
for rs in(select job from dba_jobs where upper(what) LIKE 'ZL_THIRD_MESSAGEPUSH%' AND interval ='null' and trunc(next_date)=to_date('2016-07-24','yyyy-mm-dd')) loop
dbms_job.remove(rs.job);
end loop;
end ;
注意:确保执行程序的用户拥有足够的权限