Re: run a package on the 15th of each month.

From: jwa6 <jwagans_at_yahoo.com>
Date: 9 Sep 2005 09:11:30 -0700
Message-ID: <1126282290.485547.210370@g49g2000cwa.googlegroups.com>

hello
and thanks for the response!!

I did this block to test. I get an error as you can see below..

declare

   v_date date;
  --
begin
v_date := trunc(add_month(sysdate,1))+15+(7/48);   dbms_output.put_line('v_date = '||to_char(v_date,'DD-MON-YYYY HH24:MI:SS'));

   'trunc(add_month(sysdate,1))+15+(7/48)'   end;

ORA-06550: line 5, column 17:
PLS-00201: identifier 'ADD_MONTH' must be declared
ORA-06550: line 5, column 1:

PL/SQL: Statement ignored

jim

Sybrand Bakker wrote:
> On 8 Sep 2005 12:14:12 -0700, "jwa6" <jwagans_at_yahoo.com> wrote:
>
> >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
>
> 'trunc(add_month(sysdate,1))+15+(7/48)'
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Sep 09 2005 - 11:11:30 CDT