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:
Post a Comment