-
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;
-
-
...and don't post the same question multiple times please.
So why are you using 'DAILY' when you want it to run 'HOURLY'?
-
Dbms_scheduler
ok.. my mistake i posted it twice....
basically Im not able to clear this Interval part...thats y i dont know how to schedule the job on a specific condition.Could anybody tel me if the state of job shows 'RUNNING'..and its not changin to Schedule ect.What does that mean?
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
|