Re: dbms_job

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