-
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;
-
tghsi?
dalli?
plz?
neccesary?
updations?
...it has to be Romulan, I know some Klingon but never heard such words.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
sorry
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...
-
-
Pleaseeee help us by giving your oracle version.,
-
Originally Posted by ams-jamali
Pleaseeee help us by giving your oracle version.,
It is obvious it's version 10g+
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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
|