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;