Sunday, 20 January 2013

DBMS_JOB | Oracle DBA Tutorial pdf


DBMS_JOB

Check JOB_QUEUE_PROCESSES parameter has non-zero value in initialization file.
BEGIN
SYS.DBMS_JOB.SUBMIT(
JOB => :JOB,
WHAT => 'BEGIN UPDATE_ALL_TRANS_PRICE; END;',
NEXT_DATE => TO_DATE('11-06-2004 09:54:15', 'DD-MM-YYYY
HH24:MI:SS'),
INTERVAL => 'SYSDATE+15/1440');
COMMIT;
END;

No comments: