Printable View
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'?
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?