Xref: alice comp.databases.oracle.misc:30487
Path: alice!news-feed.fnsi.net!news.new-york.net!dispose.news.demon.net!demon!news-feed.inet.tele.dk!bofh.vszbr.cz!newsmangler.inet.tele.dQ!not-for-mail
From: "Finn Ellebaek Nielsen" <fen@changegroup.dk>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Timer and Oracle 8.0.4
Date: Wed, 5 May 1999 09:22:36 +0100
Organization: ChangeGroup ApS
Message-ID: <7gorn8$2im$1@news.inet.tele.dk>
References: <7ga4sp$fb4$1@news.kabelfoon.nl> <3728E415.FDE3038E@rdbms.freeserve.co.uk>
Reply-To: "Finn Ellebaek Nielsen" <fen@changegroup.dk>
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Trace: news.inet.tele.dk 925889064 2646 195.249.171.74 (5 May 1999 07:24:24 GMT)
X-Complaints-To: Department of Abuse <abuse@news.inet.tele.dk>
NNTP-Posting-Date: 5 May 1999 07:24:24 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Lines: 31

Christopher M. Day <christopher.day@rdbms.freeserve.co.uk> wrote in message
news:3728E415.FDE3038E@rdbms.freeserve.co.uk...
> Evert,
>
> Sounds like something that could be done via Oracle Advanced Queues
> (AQ).
>
> Chris.
>
> "Evert J. Smit" wrote:
> >
> > When i've inserted a record in a specific tables I want to start a timer
> > that updates the record for example after an hour.
> >
> > Is this possible in Oracle 8.0.4.x
> >
> > If so I've no idea how to do this. Could anybody help me please.
> >
> > Thanks,
> > Evert
>
>

You could also create a job with DBMS_JOB to be run in an hours time. Take a
look at DBMS_JOB, it's quite OK for scheduling jobs (stored procedures).

HTH.

Finn