Re: Scheduling a procedure

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Sat, 21 Oct 2000 13:26:32 +0100
Message-ID: <8ss21r$m54$1@soap.pipex.net>

It is better form to

name the parameters in the dbms_job call and make the waht parameter 'BEGIN MYPROC; END;'

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Eoin Gardiner" <eoin7_at_my-deja.com> wrote in message
news:8sg17r$ahu$1_at_nnrp1.deja.com...


> Enter these commands in SQLPlus to submit a job that runs your

> procedure:

>

> variable v_jobnum number;

> begin

> dbms_job.submit(:v_jobnum, 'MY_PROCEDURE;', sysdate, 'sysdate + 1/

> (24*2)');

> end;

> /

> print v_jobnum

>

> You must also set 2 parameters in your init.ora:

>

> JOB_QUEUE_PROCESSES (set to at least 1)

> JOB_QUEUE_INTERVAL (the interval in seconds between each time that you

> want Oracle to check the job queue)

>

> HTH

>

>

> In article <jZKG5.111539$47.1432210_at_news.bc.tac.net>,

>   "Brian Neary" <bneary_at_containerworld.com> wrote:

> > Is there a facility in Oracle8i for scheduling a procedure?  I'm

 looking for


> > a way to periodically delete old data from a temporary table on my

 database


> > (Oracle 8i).  If  I build a PL/SQL procedure to delete the records I

 don't


> > need, what is the best way to have this procedure automatically  run

 twice a


> > day?

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Sat Oct 21 2000 - 07:26:32 CDT