dbms_job.submit( JOB OUT BINARY_INTEGER, WHAT IN VARCHAR2, NEXT_DATE IN DATE DEFAULTSYSDATE, INTERVAL IN VARCHAR2 DEFAULT 'NULL', NO_PARSE IN BOOLEAN DEFAULT FALSE, INSTANCE IN BINARY_INTEGER DEFAULT ANY_INSTANCE, FORCE IN BOOLEAN DEFAULT FALSE);-- To run everynight at midnight dbms_job.submit(:v_JobNo, 'proc1;', TRUNC(SYSDATE, 'DD'), 'TRUNC(SYSDATE+1,''DD'')');-- To run every ten minutes dbms_job.submit(:v_JobNo, 'proc2;', TRUNC(SYSDATE, 'HH'), 'TRUNC(SYSDATE,''MI'')+10/(24/60));-- To run every two minutes dbms_job.submit(:v_JobNo, 'proc3;, 'TRUNC(SYSDATEm 'MI'), 'TRUNC(SYSDATE,''MI'')+2/(24/60));-- To run every 30 minutes dbms_job.submit(:v_JobNo, 'proc4;', TRUNC(SYSDATE, 'HH')+ 1/24, 'TRUNC(SYSDATE,''MI'')+30/60; 仔细看看吧,会有帮助的
JOB OUT BINARY_INTEGER,
WHAT IN VARCHAR2,
NEXT_DATE IN DATE DEFAULTSYSDATE,
INTERVAL IN VARCHAR2 DEFAULT 'NULL',
NO_PARSE IN BOOLEAN DEFAULT FALSE,
INSTANCE IN BINARY_INTEGER DEFAULT ANY_INSTANCE,
FORCE IN BOOLEAN DEFAULT FALSE);-- To run everynight at midnight
dbms_job.submit(:v_JobNo, 'proc1;', TRUNC(SYSDATE, 'DD'), 'TRUNC(SYSDATE+1,''DD'')');-- To run every ten minutes
dbms_job.submit(:v_JobNo, 'proc2;', TRUNC(SYSDATE, 'HH'), 'TRUNC(SYSDATE,''MI'')+10/(24/60));-- To run every two minutes
dbms_job.submit(:v_JobNo, 'proc3;, 'TRUNC(SYSDATEm 'MI'), 'TRUNC(SYSDATE,''MI'')+2/(24/60));-- To run every 30 minutes
dbms_job.submit(:v_JobNo, 'proc4;', TRUNC(SYSDATE, 'HH')+ 1/24, 'TRUNC(SYSDATE,''MI'')+30/60;
仔细看看吧,会有帮助的