I just figured out what my issue was. And as usual, it was something I was doing wrong. Albeit it's odd it works this way.
I was assigning several values to a @BodyText variable. Building a body message really. Then sending that @BodyText to the @Body for the sql server email.
The kicker here is that if any of the values are null, or blank (??), it nulls out the whole @BodyText variable & sends nothing at all. You'd think, logically, that if a value was blank or null, it would put that in that section & just send a blank value.
Here's my example:
Set @BodyText = 'Mirroring Status Alert!!!' + CHAR(13) + CHAR(13) +
'Date: ' + @DateTime + CHAR(13) +
'Server: ' + @@ServerName + CHAR(13) +
'Database: ' + UPPER(@DatabaseName) + CHAR(13) +
'Mirror Status: ' + CAST(@MirrorStatus AS VARCHAR(1)) + ' - ' + @MirrorStatusDescription + CHAR(13) + 'Unsent Log size: ' + @UnsentLogStatus
So if @MirrorStatusDescription or @UnsentLogStatus somehow ended up blank, the whole @BodyText was blank. That's just plain silly.
Anyways...I fixed it. I'm not sure why others were experiencing it unfortunately.
JohnSQL Server 200x Newb and proud of it!