Shell Programming and Scripting

Hi

I have a shell script, it run ok if executed from the path it is located at but doesnot run when the same is tried through cron-job.

can someone help me please.

regards

gaurav shrinivas
Email address removed

Welcome to the forum. Posting your email address is against the rules.

Try this https://www.unix.com/answers-to-frequently-asked-questions/13527-cron-crontab.html

hi
thanks for the reply.
cron is working fine. some setting is required insite the programme, which i am unable to do.

need guidance.

regards

Code:

45 * * * * cd <full_path>; <script_name> >/dev/null 2

it would work...

if not..
post full details like corn job entry and script..

Thanks

gauravshrinivas, did you even check the link that vino sent? That FAQ does not even suggest that there might be a problem with cron.

Hi,
I am sending the code....
Friends please send me ur contact numbers so that i can call you and discuss in detail.
regards
-------------------------------------------------------------------

#!/bin/sh
serv=97.253.0.194
username=ftpuser
password=ftpuser
procno=$$
remdir=/u10/app/oracle/admin/NETMANDB/exp/performance/
#locdir=/usr/local/gauravs
#locdir=/cltyapps/clarity/clarity/etc/inetman_performance_script
export locdir
DTEXT=`TZ=aaa24 date +%Y%m%d`
DTEXT1=`TZ=aaa24 date +%y%m%d`
FILENAME=$DTEXT.tar.gz
FILENAME2=$DTEXT.tar
DELIMITER="_"
HOME=/cltyapps/clarity/clarity/etc/inetman_performance_script
export HOME
ORACLE_HOME=/u02/app/oracle/product/9.2.0
export ORACLE_HOME

echo user $username $password > ftp_commands_$procno
echo 'bin' >> ftp_commands_$procno
echo cd $remdir >> ftp_commands_$procno
#echo lcd $locdir >> ftp_commands_$procno
echo lcd $HOME >> ftp_commands_$procno
echo get $FILENAME >> ftp_commands_$procno
echo 'close' >> ftp_commands_$procno


$ORACLE_HOME/bin/sqlplus oss/oss@UT <<EOF
#start $locdir/remove.sql
start $HOME/remove.sql
exit
EOF

rm remove.sql
ftp -nv $serv < ftp_commands_$procno

gunzip -d $FILENAME
tar -xvf $FILENAME2
rm *.log
#mv *.dmp dumps
#cd dumps

for filename1 in *

do

xyz=`echo $filename1 | cut -d. -f1`
#echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $locdir/remove.sql
echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $HOME/remove.sql

#echo $filename1 >> /usr/local/gauravs/imp.log

$ORACLE_HOME/bin/imp file=$filename1 userid=oss/oss@UT fromuser=nm4000 touser=oss commit=y log=imp.log buffer=2000000 > imp.l
og 2>&1

#rm *.dmp

done

#cd $locdir
cd $HOME

rm *.tar
rm *.tar.gz
rm ftp_commands*

could you post your cron entry

don't ask e-mail or contact number ..pls go through this(Rules of the forum)...

https://www.unix.com/unix-for-beginners-questions-and-answers/2971-simple-rules-unix-com-forums.html