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.
Comments