We will use this step to send the email notification on success.
Step Name: Email Notification Success Enter this SQL into the Command window as seen below.
This will be the failure notification step.
Sending Automated Job Email Notifications in SQL Server with SMTP
When you have automated backup jobs running on your database server, sometimes you forget that they are even running.
