Re: dbms_job

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/01
Message-ID: <38bd8fc7.22690061@news.earthlink.net>#1/1

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

Received on Wed Mar 01 2000 - 00:00:00 CST