Update Dbms_scheduler
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Update Dbms_scheduler

  1. #1
    Join Date
    Mar 2008
    Posts
    45

    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;

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    ...and don't post the same question multiple times please.

    So why are you using 'DAILY' when you want it to run 'HOURLY'?
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  4. #4
    Join Date
    Mar 2008
    Posts
    45

    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
  •  


Click Here to Expand Forum to Full Width