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

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job

Re: dbms_job

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/02
Message-ID: <38BE3C55.107D@yahoo.com>#1/1

NetComrade wrote:
>
> variable v_job_num number;
> execute dbms_job.submit(:v_job_num, 'your_proc;);', sysdate,
> 'trunc(sysdate) +1 ');
>
> On Wed, 01 Mar 2000 20:49:42 GMT, vinay_devaki_at_my-deja.com wrote:
>
> >I have an program containing data that needs to be updated every 1-3
> >days. Currently, I am manually running the procedures to update the
> >data, i would like to automate this process. I understand there is a
> >package known as DBMS_JOB that will do this for me. I would like to
> >view some code that shows this and the procedures that it automates.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email

And of course don't forget to commit ...

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse
Received on Thu Mar 02 2000 - 00:00:00 CST

Original text of this message

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