Ora创建job定时执行某存储过程

--创建job任务，每天晚上8点执行存储过程：por_postrecords--

declare job number;

begin  

sys.dbms_job.submit(job =>job, 

what =>'pro_postrecords;',

next_date => sysdate,

interval => 'trunc(sysdate)+1+20/24'); 

commit;

end;

 

--存储过程por_postrecords--

create or replace procedure pro_postrecords as 

begin

delete from postrecords where posted_mark = 1;

end;