Wednesday, July 11, 2012

Unable to start mail session (reason: No mail profile defined) - Message in Error Log

Message
[098] SQLServerAgent terminated (normally)
This is: the most common message that will be logged when there is no "Mail Session" defined for the SQL Server Agent Alert System
.

To Fix this or to make this message disappear in the Error Log, you have to enable "Mail Session" and re-start the SQL Server Agent.
To Do this,


  • Connect to the Server
  • Right Click on the "SQL Server Agent" and go to "Properties"
  • Then Go to "Alert System" Tab
  • Make sure the check box "Enable Mail Profile" is checked
  • Click OK to exit
  • Re-start the SQL Server Agent Service

No comments:

Post a Comment