02.Oracle

oracle 스케줄 등록

1010 2017. 6. 2. 14:20
반응형

VARIABLE jobno number;

BEGIN

   DBMS_JOB.SUBMIT(

      :jobno, 

      'JOB_TRAFFIC_INFO();',

      SYSDATE,

      'TRUNC(SYSDATE+1)+7/24');

   COMMIT;

END;