oracle定时任务简单例子
DECLARE
? X NUMBER;
BEGIN
? SYS.DBMS_JOB.SUBMIT
? ( job ? ? ? => X?
? ?,what ? ? ?=> 'test;'
? ?,next_date => to_date('22/02/2013 15:52:00','dd/mm/yyyy hh24:mi:ss')
? ?,interval ?=> 'TRUNC(SYSDATE+1/1440,''MI'')'
? ?,no_parse ?=> FALSE
? );
? SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
每分钟：? ?,interval ?=> 'TRUNC(SYSDATE+1/1440,''MI'')'
每小时：? ?,interval ?=> 'TRUNC(SYSDATE+1/24,''MI'')'
