SQL Maintenance Plan with Database Mail.
Hi all,
As discussed in last two post about
1) How to Configure Database Mail in SQL Server.
2) How to create operator in SQL?
Let's see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan.
There are many Default maintenance Task available in SQL, but for demo we will be using Complete Backup Maintenance Task.
Read Complete Article »
As discussed in last two post about
1) How to Configure Database Mail in SQL Server.
2) How to create operator in SQL?
Let's see the uses of last post in this post, by creating a simple maintenance plan for taking automatic Backup from SQL and Notifying the administrator about success or failure of the Job performed by Maintenance Plan.
There are many Default maintenance Task available in SQL, but for demo we will be using Complete Backup Maintenance Task.