Re: Jobs in ORACLE

From: ole c meldahl <konocm_at_statoil.com>
Date: Tue, 23 Nov 1999 16:06:56 +0100
Message-ID: <383AAD90.91B58159@statoil.com>

Em Pradhan wrote:

> Hi
> you can run a scheduled job depending on the
> operating sistem (cron or at ) so that it
> checks the database every day and if
> finds the release date = system date
> then update the released column.
> like
> if release date <= sysdate and released = 'N' then
> update released = 'Y' where condition matches.
>

Why not DBMS_JOB, Oracles pacakge for scheduled tasks?

ole c Received on Tue Nov 23 1999 - 09:06:56 CST