SQL Server Performance

Error: An attempt was made to send an email when no email session has been established.

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 31, 2007.

  1. Anonymous New Member

    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...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/07/31/error-an-attempt-was-made-to-send-an-email-when-no-email-session-has-been-established.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1193" width="1" height="1">

Share This Page