Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    15

    Question Unanswered: Changing when a job executes

    Hi, I want to alter a database job so that it executes on the 3rd Saturday of each month. Does anyone know what the syntax for that would be?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I want to alter a database job so that it executes on the 3rd Saturday of each month
    This is not all that easy to do with DBMS_JOB.
    I had to implement this requirement,
    I have the job start EVERY Saturday.
    Within the code I have it check and if not the 3rd Saturday,
    then exit & do nothing. Only on the 3rd Saturday would
    the process continue to run & do what is needed.

Posting Permissions

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