Re: Scheduled or time trigerred events in Oracle ?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 2 Aug 2004 12:53:29 +0200
Message-ID: <410e1e28$0$25089$626a14ce@news.free.fr>

"Jérôme VUIBERT" <jerome.vuibert_at_fleximage.fr> a écrit dans le message de news:410e1481$0$31407$636a15ce_at_news.free.fr...
> Hi everybody.
>
> I would like to launch processes on my database once everyday.
>
> Is it possible to schedule this action directly in Oracle or should i pass
> by a system schedule system ?
>
> Thanks for you help.
>
> jerome
>
>

Before 10g, have a look at dbms_job.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_job.htm#999107

With 10g, have a look at dbms_scheduler. http://download-west.oracle.com/docs/cd/B13789_01/appdev.101/b10802/d_sched.htm#ARPLS138

--
Regards
Michel Cadot

Received on Mon Aug 02 2004 - 05:53:29 CDT