Re: Scheduler

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 07 Feb 1999 23:03:58 +0100
Message-ID: <36BE0DCE.D030A7B2@sybrandb.demon.nl>

The dbms_job package will run as a batch job any pl/sql procedure. You will need to define job_queue_processes = <nonzero> and job_queue_interval = <interval in seconds> in your init<sid>.ora to get this working

Hth,

Sybrand Bakker, Oracle DBA

mme wrote:

> Hello everybody!
>
> Does anybody know a way to have a scheduler in an Oracle-Server without
> writing an external program using a precompiler????
>
> I wanna have the funtionality to start a procedure at a
> predefined time (using a date/time entry in a table).
>
> Please give me feedback!!!
>
> /\/\attias

Received on Sun Feb 07 1999 - 16:03:58 CST