sounds like the path got overwritten in cron try to do the full path specification to the sqlplus binary and see if that fixes it
--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote: > Guys, > > I have a Unix shell script that runs and does some things with > sqlplus. The > script runs fine when I start it up manually just using the command > > $ host_startup.sh > > However, If I try to start this host_startup.sh from the Crontab I > get this > error logged in my mail. > > From apt2 Wed Nov 28 08:15:01 2001 > Date: Wed, 28 Nov 2001 08:15:01 GMT > Message-Id: > <[EMAIL PROTECTED]> > To: apt2 > Content-Length: 143 > > Your "cron" job on phys-ki-sun4k2 > /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh > > produced the following output: > > sqlplus: Command not found > > > Any ideas? I've specifically said in the shell script where to find > the > sqlplus binaries, so I'm not sure?! Any help would be much > appreciated. > > Cheers, > Kev. > > "I put instant coffee in a microwave oven and almost went back in > time. " > __________________ > > Kevin Thomas > Technical Analyst > Deregulation Services > Calanais Ltd. > (2nd Floor East - Weirs Building) > Tel: 0141 568 2377 > Fax: 0141 568 2366 > http://www.calanais.com > > > > > -----Original Message----- > Sent: 21 November 2001 12:20 > To: Multiple recipients of list ORACLE-L > > > > Have a look at Categoric Xalerts. > > It is a general purpose Alerting system, not just for DBA and > SYSADMs. > > Their new Java based system is just out. > > www.categoric.com > > Steve Parker > Technical Consultant > LIS > > ------------------------------ > Logistics & Internet Systems Ltd. > E Mail: [EMAIL PROTECTED] > ------------------------------ > > > > > > Kumanan Balasundaram > > <kumanan.balasundara To: Multiple > recipients > of list ORACLE-L <[EMAIL PROTECTED]> > [EMAIL PROTECTED]> cc: > > Sent by: Subject: Reliable > alerting system that is not so costly?? > [EMAIL PROTECTED] > > > > > > 21/11/2001 11:50 > > Please respond to > > ORACLE-L > > > > > > > > > > Hi there, > > Any of you using or have come across a reliable alert system that can > also > escalate > to different persons based on criteria such as how important that > system > is? > > We are looking to invest in such a software. > > Kumanan Balasundaram > Database Administrator, IT > QXL ricardo plc > www.qxl.com > P: +44 (0)208 962 7409 > > > QXL ricardo plc Registered Office Landmark House, Hammersmith > Bridge > Road, > > London W6 9EJ > > Registered in England No 3430894 VAT number - GB 701 8915 43 > > > > The information transmitted is intended only for the person or > entity to > > which it is addressed and may contain confidential and/or > privileged > > material. Any review, retransmission, dissemination or other use > of, or > > taking of any action in reliance upon, this information by persons > or > > entities other than the intended recipient is prohibited. If you > > received this in error, please contact the sender and delete the > material > > from any computer > > > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > [EMAIL PROTECTED] > > This footnote also confirms that this email message has been swept by > MIMEsweeper, Sophos and Nortons Anti-Virus, for the presence of > computer > viruses. > > ********************************************************************** > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumanan Balasundaram > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thomas, Kevin > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).