DSXchange

Code: Select all

#!/bin/ksh
################################################################################
# File Name    : RunJob.ksh
# Description  : runs DataStage job 
#              : then ftp's file for them to download
# Author       : Kim Duke
# Created      : 06/09/2005
# Modified     : 
# Invocation   : This process is called by autosys
# Prerequisites: None
# 
# Steps        : 1) extract the summary report
#                2) rename the summary report to the date-specific filename
#                3) push the summary report to the ftp site
#                4) push the .done file to the ftp site
#
# Change History
# Who              When        What
# ###############  ##########  #################################################
# Kim Duke         06/09/2005  Original Version
#
################################################################################

THIS_SCRIPT="RunJob.ksh"
EMAIL_USERS="Kim_G_Duke@hotmail.com"

FTP_SERVER="ftp.xxx.com"
FTP_USER="User Password"
FTP_DIR="/export/homeoutgoing"

CURRENT_DATE=`date +%Y%m%d`
EXTRACT_DATE=`date +'%Y%m%dT%H%M%S'`
DSHOME=`cat /.dshome`
PROJECT=$1
shift
DSJOB=$1
shift
# -param ParamName=Value
SET_PARAMS="$*"
cd $DSHOME
. ./dsenv
cd ../Projects/$PROJECT/Staging

################################################################################
# Check job status here
################################################################################
JOB_STATUS=`dsjob -jobinfo $PROJECT $DSJOB | head -1 | cut -d"(" -f2 | cut -d")" -f1`
echo "Before run JOB_STATUS=$JOB_STATUS"
case $JOB_STATUS in
################################################################################
# 0 "Running"
################################################################################
   0)
      echo "Job $DSJOB already running." | mailx -s "Error: ${THIS_SCRIPT} failed." $EMAIL_USERS 
      exit 1
      ;;
################################################################################
# Runnable Job Status (do nothing)
# 1 "Finished"
# 2 "Finished (see log)"
# 9 "Has been reset"
# 11 "Validated OK"
# 12 "Validated (see log)"
# 21 "Has been reset"
# 99 "Compiled"
################################################################################
   1|2|7|9|11|12|21|99)
      :
      ;;
################################################################################
# NOT Runnable Job Status (reset job)
# 0 "Running"
# 3 "Aborted"
# 8 "Failed validation"
# 13 "Failed validation"
# 96 "Aborted"
# 97 "Stopped"
# 98 "Not Compiled"
################################################################################
   *)
      echo "dsjob -run -mode RESET -wait $PROJECT $DSJOB"
      dsjob -run -mode RESET -wait $PROJECT $DSJOB
      RETURN_VALUE=$?
      if [ $RETURN_VALUE -ne 0 ] 
      then
         echo "Unable to reset job $DSJOB alreaady running." | mailx -s "Error: ${THIS_SCRIPT} failed." $EMAIL_USERS 
         exit $RETURN_VALUE
      fi
esac

################################################################################
# Run job here
################################################################################
echo "dsjob -run -jobstatus -wait ${SET_PARAMS} $PROJECT $DSJOB"
dsjob -run -jobstatus -wait ${SET_PARAMS} $PROJECT $DSJOB
RETURN_VALUE=$?
if [ $RETURN_VALUE -eq 1  -o $RETURN_VALUE -eq 2 ]
then
   echo job completed successfully
   EMAIL_MSG=`dsjob -report $PROJECT $DSJOB`
else
   echo "Error: $DSJOB job failed. error code was $RETURN_VALUE"
   echo "Job $DSJOB failed." | mailx -s "Error: ${THIS_SCRIPT} failed." $EMAIL_USERS 
   exit $RETURN_VALUE
fi

BASE_FILENAME=${DSJOB}_${EXTRACT_DATE}
FINAL_FILENAME=${BASE_FILENAME}.txt
DONE_FILENAME=${BASE_FILENAME}.done

################################################################################
# cat header onto job
################################################################################
echo "cat ${DSJOB}_header.txt ${DSJOB}.txt >$FINAL_FILENAME"
cat ${DSJOB}_header.txt ${DSJOB}.txt >$FINAL_FILENAME

echo done > $DONE_FILENAME

echo "ftp -n ${FTP_SERVER}"

ftp -n ${FTP_SERVER} << EOF2
user $FTP_USER

prompt
cd ${FTP_DIR}

put ${FINAL_FILENAME}
ls ${FINAL_FILENAME}

put ${DONE_FILENAME}
ls ${DONE_FILENAME}

bye
EOF2

RETURN_VALUE=$?
if [ $RETURN_VALUE -ne 0 ]
then
   echo "Ftp to $FTP_SERVER failed." 
   echo "Ftp to $FTP_SERVER failed." | mailx -s "Error: ${THIS_SCRIPT} failed." $EMAIL_USERS 
   exit $RETURN_VALUE
fi

LINES_SENT=`wc -l ${FINAL_FILENAME}`
FINISHED_DATE=`date +'%Y%m%dT%H%M%S'`

mailx -s "${THIS_SCRIPT} finished." $EMAIL_USERS << MEOF

Shell script : ${THIS_SCRIPT}
Sent files   : ${FINAL_FILENAME}
             : ${DONE_FILENAME}
To Server    : ${FTP_SERVER}
To Dir       : ${FTP_DIR}
Lines sent   : ${LINES_SENT}
Started      : ${EXTRACT_DATE}
Finished     : ${FINISHED_DATE}

$EMAIL_MSG

MEOF