sp_Blitz® Result:
Setting Failure Emails on Jobs

Being notified of Agent job status is a great way to keep track of important system items:

• Job failures, for things like DBCC CHECKDB, backups, ETL automation.
• Job completion, for things like index maintenance, so you know it doesn’t run into the production day.

You Should Only Send Emails About Job Failures

You have the option to let jobs email you when the complete, whether they succeed or fail.

Don’t do it.

If you set that up, you’re just going to create a rule. All your emails for this will go into a folder which you’ll never look at. You just lost the war. Only have jobs notify you when they fail, and don’t set up email rules. Act on every alert you get.

How TO FIX THE PROBLEM

Run the steps below for each and every job that sp_Blitz® warns you about. Don’t skip anything. (If you don’t care if a job fails, why even have the job?)
Return to sp_Blitz or Ask Us Questions

---

How to Enable Failure Emails for SQL Agent Jobs

1. Expand SQL Server Agent
2. Expand Jobs
3. Right click on a Job > Properties
4. Go to the Notifications tab
5. Click to enable Email
6. Select the correct Operator
7. Choose “When the job fails”
8. Hit OK