Re: Does Oracle Have a Timer???
From: Mikael Johansson <mjo_at_algonet.se>
Date: 1996/02/24
Message-ID: <4gnnbn$lpo_at_prometheus.algonet.se>#1/1
Date: 1996/02/24
Message-ID: <4gnnbn$lpo_at_prometheus.algonet.se>#1/1
jennings_at_dca.net (Ed Jennings) wrote:
>I'm looking for a timer for Oracle. I want to scan a staging table
>at regular intervals (say every 2 hours). I know such a feature
>exists in the replication processes, but we don't have a license for
>it. Is there another way I can accomplish this without writing a
>unix daemon to log into the database? I want to keep it all within
>the rdbms if possible.
>
>Any ideas???
You should take a look at dbms_job, which is a supplied package (at least from 7.1.6). I haven't used it myself, but it seems to be useful!
Good luck
Mikael J.
Stockholm Stock Exchange
email: mikael_at_xsse.se
Received on Sat Feb 24 1996 - 00:00:00 CET