Enable server Agent Notification

Problem

To get notified on any failed SQL Agent jobs, we need enabled mail profile and the system and profile set.

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_enable_server_agent_notification.sql

Example