Re: Scheduler

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 07 Feb 1999 20:18:42 GMT
Message-ID: <36bdf512.2916860@news.arnes.si>

On 7 Feb 1999 18:07:04 +0100, mattias.meyer_at_t-online.de (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!!!

Take a look at DBMS_JOB package, which provides exactly the functionality you are looking for. For the documentation, look in the Oracle Server Administratior's Guide under "Managing Job Queues".

>/\/\attias

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Feb 07 1999 - 14:18:42 CST