SQL Job is getting failed randomly while trying to send the alert email. need help
Pretty clearly, the mail server is sending a response to SQL Server:


  Exceeded storage allocation. The server response was: 5.3.4 Message size exceeds fixed maximum message size


The size of the email being sent by SQL Server is too large.