Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Scheduling Jobs from the Database
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 Received on Tue Jul 01 1997 - 00:00:00 CDT