oracle单次定时任务,oracle起定时任务，每隔1秒执行一次

begin

dbms_job.run(24);  -- 24jod id

--      commit;

end;

create or replace procedure backUpDayMessage as begin   insert into t_call_message_2017     select *       from t_Call_Message t      where to_char(t.visit_time, 'YYYYMMDD') =            to_char(TRUNC(sysdate - 1), 'YYYYMMDD'); end;     declare     backUpDayMessageJob number;   begin     dbms_job.submit(backUpDayMessageJob,                     what => 'backUpDayMessage;',                     next_date => TRUNC(sysdate) + 1 ,                     interval => 'TRUNC(SYSDATE) +1+ 1 / 24');       commit;   end;