Sending Automated Job Email Notifications in SQL Server with SMTP

Step Name: Email Notification Failure SQL: exec master.dbo.sp_SQLNotify ‘server@localserver.com’,’admin@localserver.com’,’Backup Job Failure,’The Backup Job failed ’ Now the idea is to make the items follow a specific workflow. First click Edit on step 1

www.howtogeek.com