Update Dbms_scheduler

[himanshu990]

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;

[gopu_g]

Refer this links..

http://youngcow.net/doc/oracle10g/appdev.102/b14258/d_sched.htm
http://www.psoug.org/reference/dbms_scheduler.html

Gopu

[chrisrlong]

...and don't post the same question multiple times please.

So why are you using 'DAILY' when you want it to run 'HOURLY'?

[himanshu990]

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?