Re: Jobs in ORACLE

Article View: comp.databases.oracle.misc

Article #120

Back to comp.databases.oracle.misc Previous Next

#120

From: ole c meldahl
Date: Tue, 23 Nov 1999 00:00

16 lines
1149 bytes

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

Technical Details

Message-ID: <383AAD90.91B58159@statoil.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3839894d@alijku02.edvz.uni-linz.ac.at> <3839CDCB.42C57F8F@dplus.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,fa9cc94c253c0626
X-Google-Attributes: gidfb53f,public
X-Google-Thread: fa4f9,fa9cc94c253c0626
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,fa9cc94c253c0626
X-Google-Attributes: gidf99a8,public
From: ole c meldahl <konocm@statoil.com>
Subject: Re: Jobs in ORACLE
Date: 1999/11/23
Message-ID: <383AAD90.91B58159@statoil.com>
X-Deja-AN: 552079797
Content-Transfer-Encoding: 7bit
References: <3839894d@alijku02.edvz.uni-linz.ac.at> <3839CDCB.42C57F8F@dplus.net>
Organization: Statoil
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,hannover.uni.comp.oracle

Reply to Parent Message