Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner AT cygwin DOT com Mail-Followup-To: cygwin AT cygwin DOT com Delivered-To: mailing list cygwin AT cygwin DOT com X-Authentication-Warning: slinky.cs.nyu.edu: pechtcha owned process doing -bs Date: Thu, 12 Dec 2002 13:26:48 -0500 (EST) From: Igor Pechtchanski Reply-To: cygwin AT cygwin DOT com To: Buck Turgidson cc: cygwin AT cygwin DOT com Subject: Re: Script Doesn't Work Correctly with Cron In-Reply-To: Message-ID: Importance: Normal MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Thu, 12 Dec 2002, Buck Turgidson wrote: > I have a script that works when I run it from the command line, but when it > is executed with cron, it produces a null file. I am sure that cron is > executing it because it creates the file. It is just not populated. > > Here is the script. I want to query an Oracle database every couple of > minutes, capture some data, and append it to a flat file. I want to keep > 2000 lines in the flat file. > > Can someone spot the error? Again, it works run from the command line. > > #!/bin/bash > sqlplus -s scott AT mydb < up @ss.sql | grep -v "Enter password:" >> > monsql.lst > tail -2000 monsql.lst > montemp.lst > rm -f monsql.lst > mv montemp.lst monsql.lst This is probably not cron-specific, but try redirecting stderr to a file (by using "2>filename") to see if the script produces any errors. Also, are all the programs you use (sqlplus, grep, tail, rm, mv) in the path for the user that cron runs as (most likely "system")? Are they executable by "system"? Igor -- http://cs.nyu.edu/~pechtcha/ |\ _,,,---,,_ pechtcha AT cs DOT nyu DOT edu ZZZzz /,`.-'`' -. ;-;;,_ igor AT watson DOT ibm DOT com |,4- ) )-,_. ,\ ( `'-' Igor Pechtchanski '---''(_/--' `-'\_) fL a.k.a JaguaR-R-R-r-r-r-.-.-. Meow! Oh, boy, virtual memory! Now I'm gonna make myself a really *big* RAMdisk! -- /usr/games/fortune -- Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple Bug reporting: http://cygwin.com/bugs.html Documentation: http://cygwin.com/docs.html FAQ: http://cygwin.com/faq/