How to Setup the Email Notificaion For Job Failure on SQL Server - SQL Server DBA Tutorial

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.

--Script:
EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'Techbrothers',
    @recipients = 'sqlagetechbrothers@gmail.com',
    @body = 'Email From TBSClient Server',
    @subject = 'Job has failed' ;

How to Setup the Email Notificaion For Job Failure on SQL Server