Optionally, we can check the Skip this page in the future checkbox before clicking on Next The Database configuration wizard opens to the Welcome page where we click on Next. Expand the Management node, right click Database Mail and select Configure Database Mail

After that, expand the instance node for which we are configuring the Database Mail for.

Configure SQL Server Agent to use Database Mailĭatabase Mail can be enabled in two ways, via Database configuration wizard or using templates, specifically Simple Database Mail Configuration script.Ĭonfiguring Database Mail using Database configuration wizardįirst off, we need to open up SSMS and connect to our server.

Setting up email notifications using SQL Server maintenance plansįor the SQL Server Agent service to be able to send email notifications for backup jobs, as well as for Maintenance plans, there are a couple of prerequisites that have to be performed first which we will go through. Setting up email notifications with SQL Server Agent In this article, we are going to cover three different ways to set up email notifications for backup jobs in SQL Server:

There are a couple of different ways to set up email notifications which can be done from Microsoft’s SQL Server Management Studio. Equally important is automatic confirmation that the backups have been successfully created for the databases with an email notification. For a SQL Server DBA handling multiple databases on any given time, knowing how to set up regular backup schedules, backups with unique names on a daily basis, making backup mirrors for redundancy, cleaning up old backup files is important.

Sql backup master free