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: Steve Long <steven.long_at_erols.com>
Date: Mon, 16 Oct 2000 18:29:34 -0400
Message-ID: <8sfvdh$9mc$1@bob.news.rcn.net>

look at package dbms_jobs and investigate AQ (advanced queuing)

"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:29:34 CDT

Original text of this message

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