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'')'
www.zzzyk.com
声明:本文来自网络,不代表【好得很程序员自学网】立场,转载请注明出处:http://www.haodehen.cn/did238322