Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: scheduled sql job on oracle
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