[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