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号