March 5, 2008 at 1:22 pm
I got this error at 1:30am, and it happend after a job run.I have gone through sql mail, agent eveything works fine and i even tested the sql mail its works fine.
is there anything i need to check
An attempt was made to send an email when no email session has been established
March 10, 2008 at 1:18 pm
Did you have chance to read the article in the following link?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322173&SiteID=1
Basically, try to restart your SQL Server Agent.
March 10, 2008 at 1:40 pm
Thanks for the reply, but i am still thinking whether its the rite way of doing or not cos i have productions box which i need to re-start the agents and i know there are couple of jobs running like replications.
Please advice me if i can re-start or not, would it harm if i do so.
once again thank you in advance.:), Have a great day
March 11, 2008 at 4:33 am
You have a problem with SQL Mail. This is the resolution process I normally follow. Re-test after each stage - when the problem is fixed, don't do the remaining steps...
1) Run xp_stopmail followed by xp_startmail. This fixes about 50% of mail problems.
2) Stop and start SQL Agent. This fixes about 45% of problems. Do not stop SQL Agent while jobs are running, or they will fail.
3) We now have a bigger problem... You now need to check if SQL Server can still contact the Exchange server using the Outlook profile. Log on to the server using the SQL Server service account and check you can open Outlook with the same Outlook profile that SQL Server uses. (You MUST use the SQL Server service account!) If any problems occurred fix them then go back to step 1. If Outlook started OK, go to step 4.
4) Restart SQL Server. This fixes about 5% of problems.
5) Reboot the box. This fixes about 1% of problems.
6) If SQL Mail still does not start, you have a very serious problem and you should call Microsoft Support (PSS).
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply