dbms_job shedule
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbms_job shedule

  1. #1
    Join Date
    Sep 2002
    Posts
    411
    how do you shedule a job using dbms_job to run every Sat at 3:00AM ???

    let sat if I have this package below:

    var j number
    begin
    dbms_job.submit
    (
    :j,
    'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''CONTRACKER'',''COMPUTE'');',
    sysdate,'sysdate+(90/(24*60*60))'
    );
    COMMIT;
    end;
    /

    The above job run very 90 sec but now I have it to run every sat at 3:00am

    thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    NEXT_DAY(trunc(sysdate)+1/8,'SATURDAY')

    [Edited by pando on 10-10-2002 at 04:33 PM]

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