Hi all,
I configured Database mail on my SQL Instance to notify job alerts and when I tested Database Mail by sending a Test email , It worked and I received the email.
but some how I don't know it isn't happening in the case when job fails and I configured agent to use this Database Mail profile to send notifications.
but still some how in my error log I'm getting this error message and no body in that group are receiving the emails
"An attempt was made to send an email when no email session has been established"
please help me with this, did any body come across the same thing?
Our community of experts have been thoroughly vetted for their expertise and industry experience.