Home » Infrastructure » Unix » Cron job to login into SQLPLUS and run a script
Cron job to login into SQLPLUS and run a script [message #98026] Fri, 14 November 2003 13:51 Go to next message
Ray
Messages: 58
Registered: January 2000
Member
I have a script file that I would like to run once every hour. The script file does inserts into a database that simulates incoming live feed data. I need to login into sqlplus then run the script file. These files, DB's, and all can be run from the same solaris 8 box.

scriptfile = sqlload.sql
unix = solaris 8
owner = abc123
password = temp
cron entry 0 0-23 * * * /bin/sh ???????????

I haven't used cron like this before as I am somewhat new but if Anyone can help it will be greatly appreciated.
Re: Cron job to login into SQLPLUS and run a script [message #98031 is a reply to message #98026] Mon, 17 November 2003 13:01 Go to previous message
Ray
Messages: 58
Registered: January 2000
Member
It is now working correctly.
Previous Topic: Memory default(core dump)
Next Topic: oracle 8.1.6installation problem
Goto Forum:
  


Current Time: Tue Sep 22 05:01:18 CDT 2020