Results 1 to 3 of 3

Thread: Dbms_job.submit

  1. #1
    Join Date
    Sep 2002
    Posts
    6

    Question Unanswered: Dbms_job.submit

    Hi,

    How I can submit a job to run each Saturday at 05:00:00 (AM)


    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Dbms_job.submit

    Originally posted by saadh
    Hi,

    How I can submit a job to run each Saturday at 05:00:00 (AM)

    Thanks in advance
    Do this:

    declare
    j number;
    begin
    dbms_job.submit
    ( j,
    'the_job;',
    NEXT_DAY(TRUNC(SYSDATE)-1,'SAT')+5/24,
    'NEXT_DAY(TRUNC(SYSDATE),''SAT'')+5/24'
    );
    end;

  3. #3
    Join Date
    Oct 2002
    Location
    Madrid - SPAIN
    Posts
    13
    Hi,

    You have a full explanation about jobs at:

    http://download-west.oracle.com/docs.../jobq.htm#8312

    I hope this help you...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •