This video explains step by step process of setting up the email notification if SQL Server Agent Job fails. It explains using SQL Server agent notification where you configure the Job system alert to send an email in case job fails or completes. It also shows step by step process of using sp_send_email notification store procedure to use in SQL Server agent job and notify operator in case job fails.
Blog post link for the video
http://sqlage.blogspot.com/2015/04/how-to-setup-email-notificaion-for-job.html
Visit our website to check out SQL Server DBA Tutorial Step by Step
http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
