rpoblem in running script

Hi friends.....Please help me....
I have written script like below.....
#!/bin/ksh (even #!/bin/awk -f also works and I tried)
awk -f program1 filename > filename2
awk -f program2 filename2 > scriptfile
ksh scriptfile

when I run it manullay it is working fine.....I am happy.
when I put it in crontab it is putting me in sad saying
scriptfile not found...but when I do ls -lrt file is there...what is the problem.
should I include WAIT or SLEEP before executing scriptfile...
I gave pull path even in script and tried...I got the same message in MAIL...
permission is okay...for the same permission ksh works manullay..I
have tried too....help please.
Thanks.
Thanigai.

On the crontab try giving the full path


i.e

/usr/local/.../scriptfile make sure the file permissions for the scriptfile had been set appropriately.

else change it to

chmod 750 scriptfile

Hope this would help you.
Sam

Thanks SAM...
I am doing with full path only.....and ofcourse with
chmod 700 scriptfile ......
sTILL it doesn't work.....
I added....'wait' after the chmod and before the ./scriptfile to recognise
the file from the directory....It is interesting..
still it says file not found....but it does chmod 700.....
wait a second,is it (may be) because the shell in awk...?.Please help.
Thanks.
Thanigai.

You must preface every file with the correct path if you are running from the crontab. I like to set an environment variable at the beginning of the script to define my directory and then preface the entries in the script with that environment variable.

For example:
#!/bin/ksh
SCRIPT_DIR=/u01/scripts
awk -f $SCRIPT_DIR/program1 $SCRIPT_DIR/filename > $SCRIPT_DIR/filename2
awk -f $SCRIPT_DIR/program2 $SCRIPT_DIR/filename2 > $SCRIPT_DIR/scriptfile
ksh $SCRIPT_DIR/scriptfile

Hi friends Still I have the problem....I have given the full path too....
Please help me out.....
Here is the script I am running......in crontab....


more ALERTLOG_TRIM

#!/bin/ksh
SCRIPT_DIR=/apps/oracle/bckup_scripts/TRIMLOG
export SCRIPT_DIR
#echo $SCRIPT_DIR
awk -f $SCRIPT_DIR/DBnames /var/opt/oracle/oratab > $SCRIPT_DIR/List_NAMES
awk -f $SCRIPT_DIR/Log_Trim $SCRIPT_DIR/List_NAMES > $SCRIPT_DIR/Trimlog
ksh $SCRIPT_DIR/Trimlog

more List_NAMES
SID1
SID2
SID3
SID4
SID5


more Trimlog
#!/bin/ksh
. $HOME/.profile
DUMP=`sqlplus -s system/passwd@SID1 @background_dump_dest.sql`
ALERTLOG=$DUMP/alert_SID1.log
export ALERTLOG
if
[[ -f $ALERTLOG ]]; then
cp $ALERTLOG $DUMP/alert_SID1.log.old
tail -100 $ALERTLOG > $DUMP/project/alert_SID1.log
cp $DUMP/project/alert_SID1.log $ALERTLOG
rm $DUMP/project/alert_SID1.log
fi
#!/bin/ksh
. $HOME/.profile
DUMP=`sqlplus -s system/passwd@SID2 @background_dump_dest.sql`
ALERTLOG=$DUMP/alert_SID2.log
export ALERTLOG
if
[[ -f $ALERTLOG ]]; then
cp $ALERTLOG $DUMP/alert_SID2.log.old
tail -100 $ALERTLOG > $DUMP/project/alert_SID2.log
cp $DUMP/project/alert_SID2.log $ALERTLOG
rm $DUMP/project/alert_SID2.log
fi
..............continues for all sids.....

fi
Bye...


still it says $SCRIPT_DIR/Trimlog not found....please help.
Thanks.
Thanigai.