Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: scheduled sql job on oracle

Re: scheduled sql job on oracle

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Tue, 3 Nov 1998 07:19:16 +0100
Message-ID: <71m7b3$hjq$1@newton.a2000.nl>


David Sisk wrote
> the simplest of which is:

Hehe, I would say the simplest is writing a stored procedure, which can be triggered by the standard dbms_jobs package. This way you're absolutely sure that the database is running when your SQL is running, for otherwise the job would not have been started. Of course, it will be hard to capture output.

Arjan. Received on Tue Nov 03 1998 - 00:19:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US