select * from all_jobsѯ洢̼ƻ

declare job number; begin dbms_job.submit(job,'PROC_SH_JOB;',sysdate,'sysdate+1/24'); dbms_job.run(job); end;
ɾ
begin dbms_job.remove(84);end; --begin dbms_job.broken(26,true);end;
շı
truncate table STAT_PRODUCT_DAILY
