day13_先沃联盟定时任务

【原来 interval =>  'sysdate+10/1440' 】

DECLARE

X NUMBER;

BEGIN

SYS.DBMS_JOB.SUBMIT

( job => X

,what => 'PRC_TABLE_WLM_SOLR_DATA;'

,next_date => to_date( '21-11-2014 14:42:00 ', 'dd-mm-yyyy hh24:mi:ss ')

,interval =>  'sysdate+10/1440' 

,no_parse => FALSE

);

COMMIT;

END;

/ 

【现在 interval =>  'trunc(sysdate,''mi'')+10/1440'】

DECLARE

X NUMBER;

BEGIN

SYS.DBMS_JOB.SUBMIT

( job => X

,what => 'PRC_TABLE_WLM_SOLR_DATA;'

,next_date => to_date( '07-01-2015 11:02:00 ', 'dd-mm-yyyy hh24:mi:ss ')

,interval =>  'trunc(sysdate,''mi'')+20/1440' 

,no_parse => FALSE

);

COMMIT;

END;

/ 

来自为知笔记(Wiz)