- Configure Database Mail.
- Create a SQL Server job.
- Adjust the properties within the SQL Server Agent.
- Create an Operator.
- Adjust the SQL Server job to send on Failure
Refer Here for Step by Step Configuration.
Refer Here for Step by Step Configuration.