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/