Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling a procedure

Re: Scheduling a procedure

From: Brian Neary <bneary_at_containerworld.com>
Date: Mon, 16 Oct 2000 15:41:53 -0700
Message-ID: <JvLG5.111556$47.1432580@news.bc.tac.net>

I just found the DBMS_JOB package. I think I'm on my way. Brian Neary <bneary_at_containerworld.com> wrote in message news:jZKG5.111539$47.1432210_at_news.bc.tac.net...
> 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?
>
>
Received on Mon Oct 16 2000 - 17:41:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US