Enable Failure Email for SQL Agent Jobs
How to Enable Failure Emails for SQL Agent Jobs Expand SQL Server Agent. Expand Jobs. Right click on a Job > Properties. Go to the Notifications tab. Click to enable Email. Select the correct Operator. Choose “When the job fails” Hit OK. Note: Make sure the SQL Server Mail Account and Profile has been setup correctly.