JobStat=`dsjob -report $Project $i | grep status | awk -F= ' { print $2; } ' | awk ' { print $1; } '`;
if [ "$SysDate" == "$JobRunDate" ] && [ "$JobStTime" -ge "$CurSysHrs" ] && [ [ "x3" >= "x${JobStat}" ] || [ "x0" != "x${JobStat}" ] || [ "x2" != "x${JobStat}" ] ] 
then
{
echo "$JobName,$StartTime,$EndTime,$JobStat" >>$Jobstatus
}
fi

 
#!/usr/bin/sh
#Scripted by Raju B on Aug062011#
#Datastge Jobs monitoring script
cd /QIS2FTP/scripts/Scripts
#Removing Last Run Jobstatus.txt file.
rm /QIS2FTP/scripts/Scripts/Jobstatus.txt
#Printing Output in Jobstatus.txt
Jobstatus=/QIS2FTP/scripts/Scripts/Jobstatus.txt
echo "JobName,StartDateTime,EndDateTime,Status " >>$Jobstatus
echo "------------------------------------------------------------" >>$Jobstatus
#set -x
# import my environment
. /QIS2FTP/dsclientprod/home/my.env
#Variables declaration
#List of all jobs in DS QIS2 Project
DSJoblist=`dssearch -ljobs -matches -sub -oc QIS2 * |cut -f2 -d'\'|awk '{print $1}'`
Project=QIS2
SysDate=`date +%Y%m%d`
 
for i in $DSJoblist
do
#DSJobStatus variable for collecting Job start and End time,Job duration and Job status
DSJobStatus=`dsjob -report $Project $i 2> /dev/null | grep "Job" | cut -f2 -d'='`
StartTime=`echo $DSJobStatus | cut -f1,2 -d' '`
EndTime=`echo $DSJobStatus | cut -f3,4 -d' '`
JobStat=`dsjob -report $Project $i | grep status | awk -F= ' { print $2; } ' | awk ' { print $1; } '`;
JobName=`dssearch -ljobs -matches -sub -oc QIS2 $i`
#Dateformat 20110805
JobRunDate=`echo $StartTime |awk '{print $1}'|sed 's/-//'|sed 's/-//'`
#Time in hours ex: 09
JobTimeH=`echo $StartTime |awk '{print $2}'|cut -f1 -d':'`
JobTimeM=`echo $StartTime |awk '{print $2}'|cut -f2 -d':'`
JobStTime=`echo "$JobTimeH$JobTimeM"`
#Going 4 hour back from local time zone EST.
CurSysHrs=`TZ=GTM+1:00 date '+%H%M'`
#echo "Print Current time before 4 hours $CurSysHrs"
if [ "$SysDate" == "$JobRunDate" ] && [ "$CurSysHrs" -ge "$JobStTime" ]
then
if [ "x1" == "x${JobStat}" ]
then
echo "$JobName,$StartTime,$EndTime,$JobStat" >>$Jobstatus
fi
fi
# if [ "$SysDate" == "$JobRunDate" ] && [ "$CurSysHrs" -ge "$JobStTime" ]
# then if [ "x0" != "x${JobStat}" ]
# then 
# echo "$JobName,$StartTime,$EndTime,$JobStat" >>$Jobstatus
# 
# fi 
# fi
# if [ "$SysDate" == "$JobRunDate" ] && [ "$CurSysHrs" -ge "$JobStTime" ]
# then if [ "x2" != "x${JobStat}" ]
# then 
# echo "$JobName,$StartTime,$EndTime,$JobStat" >>$Jobstatus 
# fi 
# fi
done
#set +