|
-
Update Dbms_scheduler
hi guyz,,,
i need to run tghsi dalli after every 1 hour..plz make the neccesary updations...change
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
JOB_NAME => 'RUN_HLC_UPDATE',
JOB_TYPE => 'CHAIN',
JOB_ACTION => 'CHAIN_HLC_UPDATE', /*CHAIN NAME*/
START_DATE => ' 10-APR-08 11.50.00 PM -07:00',
REPEAT_INTERVAL => 'FREQ = DAILY ; INTERVAL =1; BYHOUR = 23 ; BYMINUTE = 59',
ENABLED => TRUE);
END;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|