host=hostname
now=date +"%d-%b-%y"
now=echo $now| tr '[a-z]' '[A-Z]'
yest=TZ=CST+24 date +%d-%b-%y
yest=echo $yest| tr '[a-z]' '[A-Z]'
sub="Jobs-$host-$now-HealthReport"
if [ -s jobs.csv ] then awk 'BEGIN{ FS="," print """HSCR-DBMSJOB HEALTH REPORT " print "" print """SUMMARY" print "" print "<trbgcolor='#FFFFCC'>"
print "BROKENSCHEMA_USERJOB_IDLAST_DATELAST_SECTHIS_DATE" print "THIS_SECNEXT_DATENEXT_SECNAME" }
{ printf "" for(i=1;i<=10;i++){
host=`hostname`
now=`date +"%d-%b-%y"`
now=`echo $now| tr '[a-z]' '[A-Z]'`
yest=`TZ=CST+24 date +%d-%b-%y`
yest=`echo $yest| tr '[a-z]' '[A-Z]'`
sub="Jobs-$host-$now-HealthReport"
if [ -s jobs.csv ]
then
awk 'BEGIN{
FS=","
print "<HTML>""<TABLE border=1 width='100%' align='centre' ><tr bgcolor='#000080'><TH><FONT COLOR='#FFFFFF'>HSCR-DBMSJOB HEALTH REPORT </TH></FONT>"
print "</TABLE>"
print "<HTML>""<TABLE border=1 width='100%' align='centre' bgcolor='#C6C6C6' BORDERCOLOR='#CCFF00' ><tr bgcolor='#5F9EA0'><TH>SUMMARY</TH>"
print "</TABLE>"
print "<HTML><TABLE border=2 width='100%' align='centre' BORDERCOLOR='#330000' ><trbgcolor='#FFFFCC'>"
print "<TH>BROKEN</TH><TH>SCHEMA_USER</TH><TH>JOB_ID</TH><TH>LAST_DATE</TH><TH>LAST_SEC</TH><TH>THIS_DATE</TH>"
print "<TH>THIS_SEC</TH><TH>NEXT_DATE</TH><TH>NEXT_SEC</TH><TH>NAME</TH>"
}
{
printf "<TR>"
for(i=1;i<=10;i++){
if(i == 1 && $i == "N" || i == 4 && $i == n || i == 4 && $i == y )
{
printf "<TD bgcolor='#75923C'>%s</TD>", $i
}
else if(i == 1 && $i == "Y" || i == 4 && $i != n && $i != y)
{
printf "<TD bgcolor='#FF0000'>%s</TD>", $i
}
else
{ printf "%s", $i } } print "" }
END{
{
printf "<TD>%s</TD>", $i
}
}
print "</TR>"
}
END{
print "</TABLE></BODY></HTML>"
}' y="$yest" n="$now" jobs.csv > jobstatus-$host-$now.html
else
echo "file not found"
fi
else echo "file not found"
fi
