Re: Scheduling a procedure

From: Eoin Gardiner <eoin7_at_my-deja.com>
Date: Mon, 16 Oct 2000 22:59:11 GMT
Message-ID: <8sg17r$ahu$1@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 Mon Oct 16 2000 - 17:59:11 CDT