Re: dbms_job

O'Reilly press has an excellent book on the Oracle supplied packages. It hasn't been brought up to date in awhile, but all the older packages including dbms_job are well described and include examples.

Van

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:38bd8fc7.22690061_at_news.earthlink.net...
> 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 Thu Mar 02 2000 - 00:00:00 CST