Error: An attempt was made to send an email when no email session has been established.
What to do when you get the error specified on the subject above?
You might get this error message from a job which will send email to an operator when it is completed. First thing to check whether a valid email has been mentioned in the operator. Also there are few other steps involved that involves restarting SQL Server Agent service, here it is:
- In Management Studio, right-click on SQL Server Agent and select "Properties."
- Click "Alert System"
- Unclick "Enable mail profile"
- Click "OK"
- Right-click SQL Server Agent again and select "Properties."
- Click "Alert System"
- Re-click "Enable mail profile"
- Click "OK"
- Restart SQL Server Agent
Also look at the MS186358 article on MSDN to resolve the issue.