Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling a procedure
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