Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail From: "jwa6" Newsgroups: comp.databases.oracle.misc Subject: 15th of every month for jobs running Date: 9 Sep 2005 10:39:00 -0700 Organization: http://groups.google.com Lines: 37 Message-ID: <1126287540.751183.258500@g14g2000cwa.googlegroups.com> NNTP-Posting-Host: 165.189.7.2 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1126287545 21568 127.0.0.1 (9 Sep 2005 17:39:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 9 Sep 2005 17:39:05 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g14g2000cwa.googlegroups.com; posting-host=165.189.7.2; posting-account=zz6wYgwAAABvJ0uZOyOMkrLtiq6tTA3z Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:121751 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 :=3D trunc(add_month(sysdate,1))+15=AD+(7/48); dbms_output.put_line('v_date =3D '||to_char(v_date,'DD-MON-YYYY HH24:MI:SS')); 'trunc(add_month(sysdate,1))+1=AD5+(7/48)' end; ORA-06550: line 5, column 17: PLS-00201: identifier 'ADD_MONTH' must be declared ORA-06550: line 5, column 1:=20 PL/SQL: Statement ignored