Re: Firing code based on date (date based trigger?)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/02/29
Message-ID: <38bc431b.32027848@news.demon.nl>#1/1

On Tue, 29 Feb 2000 21:51:06 GMT, kevin_g_at_my-deja.com wrote:

>Hi,
>Does anyone know how I trigger a piece of code based on the date.
>ie if I wanted to run a particular PL/SQL procedure every Sunday at 2am.
>I'm using 8.1.5 (NT)
>(Probably a simple question...)
>
>Thanks,
>Kevin
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

check out the dbms_job package.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Feb 29 2000 - 00:00:00 CST