【原来 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;
/