15th of every month for jobs running

From: jwa6 <jwagans_at_yahoo.com>
Date: 9 Sep 2005 10:39:00 -0700
Message-ID: <1126287540.751183.258500@g14g2000cwa.googlegroups.com>

I want a job to run at 330 am on the 15th of every month.

>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


>        v_proc          -- procedure to run,

>        v_run_date,     -- Next date/time to run

>        -- Interval              if null dont run but once

> v_run_date -- this will set the run to the 15 of each month

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 Received on Fri Sep 09 2005 - 12:39:00 CDT