UNIX for Advanced & Expert Users

32 11 * * 1 /home/sadeadm/data/LMC/accept/WeeklyLabor/sql_loader/sftp_testing/sftp_testing.job abusmgt /appl/oracle1/product/10.2.0.4 /appl/oracle1

32 11 * * 1 /home/prodid/data/LMC/accept/WeeklyLabor/sql_loader/sftp_testing/sftp_testing.job abusmgt /appl/oracle1/product/10.2.0.4 /appl/oracle1
 
And here is the file sftp_testing.job that I want cron to execute:
 
#!/bin/sh
##########################################################################
##
## Declarations.
##
## HOMEDIR=/home/prodid/data/LMC/prod/WeeklyLabor
HOMEDIR=/home/prodid/data/LMC/accept/WeeklyLabor
DATADIR=${HOMEDIR}/sql_loader/sftp_testing/
LOGDIR=${DATADIR}/log_files
LOG=${LOGDIR}/sftp_testing.logfile
TODAY=`date "+DATE: %m/%d/%y TIME: %H:%M:%S %p"`
FILEDATE=`date "+%Y%m%d"`
DFILE=zc00799i_pch.out
##
## Process Passed-in Parameter Values
##
ORACLE_SID=$1
export ORACLE_SID
ORACLE_HOME=$2
export ORACLE_HOME
ORACLE_BASE=$3
export ORACLE_BASE
##
## Directory for sqlldr and sqlplus
##
BINDIR=${ORACLE_HOME}/bin
cd ${DATADIR}
echo SAP_NODE_FTP JOB STARTING.........
echo "SAP_NODE_FTP JOB STARTING........." > ${LOG}
if [ -f ${DFILE} ]
then
  rm ${DFILE}
fi
echo "ORACLE_SID:   " >> ${LOG}
echo ${ORACLE_SID} >> ${LOG}
echo "ORACLE_HOME:  " >> ${LOG}
echo ${ORACLE_HOME} >> ${LOG}
echo "ORACLE_BASE:  " >> ${LOG}
echo ${ORACLE_BASE} >> ${LOG}
echo " " >> ${LOG}
echo "#########" >> ${LOG}
echo "File ${DFILE} FTP Operation starting at: " >> ${LOG}
echo ${TODAY} >> ${LOG}
echo "#########" >> ${LOG}
echo " " >> ${LOG}
echo Files to be retrieved from Remote System: >> ${LOG}
echo ${DFILE} >> ${LOG}
echo Oracle Environment: >> ${LOG}
echo ${ORACLE_SID} >> ${LOG}
echo "Bin directory (BINDIR): " >> ${LOG}
echo ${BINDIR} >> ${LOG}
echo " " >> ${LOG}
##
## Connect to Source System and Retrieve PCNODE file.
HOST="sscprd.testing.com"
USER="ficoftp"
sftp ${USER}@${HOST} << EOF >> ${LOGDIR}/sftp_testing.logfile
  cd ../
  cd FTPOUT
  get ${DFILE}
  quit
EOF

echo " " >> ${LOG}
echo "#########" >> ${LOG}
echo FTP Operation Complete. File Listing: >> ${LOG}
echo "#########" >> ${LOG}
ls -lrt >> ${LOG}
echo " " >> ${LOG}
echo "###" >> ${LOG}
echo "Number of records in retrieved file: "`wc -l < ${DFILE}` >> ${LOG}
echo "###" >> ${LOG}
echo " " >> ${LOG}
echo " " >> ${LOG}
echo "#########" >> ${LOG}
TODAY=`date "+DATE: %m/%d/%y TIME: %H:%M:%S %p"`
echo ${TODAY} >> ${PAGERLOG}
echo "sftp_testing.JOB ending at: " >> ${LOG}
echo ${TODAY} >> ${LOG}
echo "#########" >> ${LOG}
cat ${LOG} > ${LOGDIR}/sftp_testing.shlog
mailx -s "sftp_testing Job: ${ORACLE_SID}" `cat ${HOMEDIR}/patrick_mail_list.txt` < ${LOGDIR}/sftp_testing.shlog
echo sftp_testing JOB COMPLETE.