Re: Scheduling Jobs from the Database

From: Lawrence Simela <lsimela_at_cix.compulink.co.uk>
Date: 1997/07/12
Message-ID: <ED7ozz.8Cp@cix.compulink.co.uk>#1/1

>>I am using version 7.1.6 of Oracle on UNIX(Solaris) - the version
>>that doesnt include UTL_FILE and >>DBMS_JOB.

>>What is the best way of running UNIX shell scripts whose execution
>>strings are stored in an Oracle >>table. I am currently looking at
using Host but this is not very >>elegant.

>>Eg.
>>spool command_file
>>Select command_string
>> from JOB;
>>Spool Off

>>!chmod +x command_file.lst
>>!nohup command_file.lst &

>>Regards

You can crontab (unix command/utility) your little script to be executed by UNIX at given times.

Lawrence Simela Mahalini Consulting Limited. Received on Sat Jul 12 1997 - 00:00:00 CDT