DBMS_JOB

BEGIN
  SYS.DBMS_JOB.REMOVE(272);
COMMIT;
END;
/

DECLARE
  X NUMBER ;
BEGIN
  SYS.DBMS_JOB.SUBMIT
  ( job       => X
   ,what      => 'APPMGR.tmplog_clear.clear_main;'
   ,next_date => to_date('12-11-2010 13:50:00','dd/mm/yyyy hh24:mi:ss')
   ,interval  => 'trunc(sysdate)+1+14/24+30/1440'
   ,no_parse  => FALSE
  );
  SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
/* 
  SYS.DBMS_JOB.BROKEN
   (job    => X,
    broken => TRUE);
*/
COMMIT;
END;
/

 

立即执行某个Job:

exec SYS.DBMS_JOB.RUN(275)

 

括号里面是这个Job的id号