Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> run a package on the 15th of each month.

run a package on the 15th of each month.

From: jwa6 <jwagans_at_yahoo.com>
Date: 8 Sep 2005 12:14:12 -0700
Message-ID: <1126206852.453150.204880@g43g2000cwa.googlegroups.com>


hello
I have a job I ouuld like to submit to delete historical data. I need the job to run the 15th of every month at 330 am. I am not sure how to get the date right ( IE the 15th)for the Interval parm I need to pass w/ the DBMS_JOB.SUBMIT function.

 DBMS_JOB.SUBMIT(v_JobNum,     -- Return of job number
        'PA_SSA_FELONREC_LOAD.SP_INSERT_EVSFUFEL;',
        v_run_date,            -- Next date/time to run

-- Interval if null dont run but once
-- this will set the run to the 15 of each month
Received on Thu Sep 08 2005 - 14:14:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US