Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Scheduler
A copy of this was sent to mattias.meyer_at_t-online.de (mme)
(if that email address didn't require changing)
On 7 Feb 1999 18:04:34 +0100, you 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
>
>
look at that dbms_job package. a quick review can by found in sqlplus by:
SQL> select text from all_source where name ='DBMS_JOB' and type = 'PACKAGE' order by line;
that'll do it for you.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Feb 07 1999 - 16:08:36 CST