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(sy
原创
2010-11-12 17:07:00 ·
508 阅读 ·
0 评论