Re: PL/SQL - Sheduler for SQL-Scripts

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Tue, 16 Feb 1999 22:31:16 +0000
Message-ID: <36C9F1B4.B7D9CF98@rdbms.freeserve.co.uk>

Schlumpf ,

Why not use the External Procedure method within Oracle8 (EXTPROC) combined with dbms_job.

create a library, and map to the function system()
call system() with '/oracle/home/sqlplus ....'

Chris

Schlumpf wrote:
>
> Is their a way to start *.sql scripts
> on an specificate time automatically?
>
> I know the jobque but i think i cant use
> the start commando in an PL/SQL
>
> Please help me .. its really important !!
Received on Tue Feb 16 1999 - 16:31:16 CST