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'')'