This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
Script Doesn't Work Correctly with Cron
- From: "Buck Turgidson" <jc_va at hotmail dot com>
- To: <cygwin at cygwin dot com>
- Date: Thu, 12 Dec 2002 13:07:51 -0500
- Subject: Script Doesn't Work Correctly with Cron
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@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
--
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/