DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'USERID.PROCID;'
,next_date => TO_DATE('15-11-2008 07:00:00','dd/mm/yyyy hh24:mi:ss')
,INTERVAL => 'TRUNC(SYSDATE+1)+7/24'
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || TO_CHAR(x));
END;
/
COMMIT;
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'USERID.PROCID;'
,next_date => TO_DATE('15-11-2008 07:00:00','dd/mm/yyyy hh24:mi:ss')
,INTERVAL => 'TRUNC(SYSDATE+1)+7/24'
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || TO_CHAR(x));
END;
/
COMMIT;
'Db > Oracle' 카테고리의 다른 글
Oracle Package Procedure Sample (2) | 2010.04.06 |
---|---|
Oracle 암/복호화 Package Function Sample(dbms_obfuscation_toolkit) (3) | 2010.04.06 |
Oracle function sample (4) | 2010.04.06 |
Oracle 세로 데이터를 가로로 표현 (1) | 2010.04.06 |
Oracle split 구현 (2) | 2010.04.06 |