User is not able to send the html format content over the mail, it coming in distorted way. below is solution proposed to resolve it.
Add orange content is html format file.
#-> cat body_text.txt
From: abct@bcs.com
To: abct@bcs.com
Subject: MIME Test
Mime-Version: 1.0
Content-Type: text/html
<html><body><font color="#1F497D"> Hi Team,</br></br>Count of HIVE tables against Teradata staging tables is not same for validity date '''2018-11-18'''.</br></br></font><table border="1" ><tr><td align="center" bgcolor="#2F75B5" valign="top"><font color="white">Hive Table Name</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Hive Count</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Teradata Table Name</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Teradata Count</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Status</font></td></tr><tr><tr><td align="left" valign="top">GSGO_M09_TD_F42199_H</td><td align="left" valign="top">317067288</td><td align="left" valign="top">M09_TD_F42199_H</td><td align="left" valign="top">308660931</td><td align="center" bgcolor="#C00000" valign="top"><font color="white">FAILED</font></td></tr><tr><td align="left" valign="top">GSGO_M29_TD_BIC_OHZDP_HC045_H</td><td align="left" valign="top">19682893</td><td align="left" valign="top">M29_TD_BIC_OHZDP_HC045_H</td><td align="left" valign="top">19954073</td><td align="center" bgcolor="#C00000" valign="top"><font color="white">FAILED</font></td></tr><tr><td align="left" valign="top">GSGO_M02_TD_F3102_H</td><td align="left" valign="top">62696104</td><td align="left"
#cat body_text.txt |sendmail -t
Add orange content is html format file.
#-> cat body_text.txt
From: abct@bcs.com
To: abct@bcs.com
Subject: MIME Test
Mime-Version: 1.0
Content-Type: text/html
<html><body><font color="#1F497D"> Hi Team,</br></br>Count of HIVE tables against Teradata staging tables is not same for validity date '''2018-11-18'''.</br></br></font><table border="1" ><tr><td align="center" bgcolor="#2F75B5" valign="top"><font color="white">Hive Table Name</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Hive Count</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Teradata Table Name</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Teradata Count</font></td><td align="left" bgcolor="#2F75B5" valign="top"><font color="white">Status</font></td></tr><tr><tr><td align="left" valign="top">GSGO_M09_TD_F42199_H</td><td align="left" valign="top">317067288</td><td align="left" valign="top">M09_TD_F42199_H</td><td align="left" valign="top">308660931</td><td align="center" bgcolor="#C00000" valign="top"><font color="white">FAILED</font></td></tr><tr><td align="left" valign="top">GSGO_M29_TD_BIC_OHZDP_HC045_H</td><td align="left" valign="top">19682893</td><td align="left" valign="top">M29_TD_BIC_OHZDP_HC045_H</td><td align="left" valign="top">19954073</td><td align="center" bgcolor="#C00000" valign="top"><font color="white">FAILED</font></td></tr><tr><td align="left" valign="top">GSGO_M02_TD_F3102_H</td><td align="left" valign="top">62696104</td><td align="left"
#cat body_text.txt |sendmail -t
No comments:
Post a Comment