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;

[PAVB]

tghsi?
dalli?
plz?
neccesary?
updations?

...it has to be Romulan, I know some Klingon but never heard such words.

[himanshu990]

I apologise ... for that.it was my mistake...I usually write without lookin at what Im wiritng .....

Can u put some light on the code here its once again:-
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
JOB_NAME => 'RUN_HLC_UPDATE',
JOB_TYPE => 'CHAIN',
JOB_ACTION => 'CHAIN_HLC_UPDATE', /*CHAIN NAME*/
START_DATE => '13-APR-08 11.00.00 PM ',
REPEAT_INTERVAL => 'FREQ = HOURLY;INTERVAL = 1; BYDAY = MON,TUE,WED,THU,FRI,SAT,SUN ',
ENABLED => TRUE);
END;


Now the thing is I need to run this job after every single hour every day.
I tried to change the "Repeat Interval" .It runs but comes to "Stall" after that and does'nt run for the consecutive hours.Kindly help me out...

[himanshu990]

pleaseeeeeeeeee help....

[ams-jamali]

Pleaseeee help us by giving your oracle version.,

[LKBrwn_DBA]

Pleaseeee help us by giving your oracle version.,

It is obvious it's version 10g+