OraFAQ Forum: Unix » Cron job to login into SQLPLUS and run a script

Home » Infrastructure » Unix » Cron job to login into SQLPLUS and run a script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cron job to login into SQLPLUS and run a script [message #98026]

Fri, 14 November 2003 13:51

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.

Report message to a moderator

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

Ray
Messages: 58
Registered: January 2000

Member

It is now working correctly.

Report message to a moderator

Previous Topic:	Memory default(core dump)
Next Topic:	oracle 8.1.6installation problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 09:00:05 CST 2021