Enabling email notifications in the SQL Agent for Alerting & Job monitoring

To enable email notifications in SQL Agent you will need to follow the following steps:

1. Configure Datbase Mail: create an email SMTP account and corresponding Email Profile. To do so please follow directions outlined in the blog post: "SQL Database Mail - Send Emails from SQL Server".

2. In SSMS (SQL Server Managment Studio) select SQL Server Agent node and right click on the properties (see image below). If the properties menu item is disabled than it is because your SQL Agent service is not running. Please start the Agent before accessing the properties.

Note: We do consider to allow the access to the Agent properties on not running instance as well (in one of our future releases)

Read more: SQL Server Agent Team Blog

Posted via email from .NET Info