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.

Last modified: July 24, 2020

Author

Comments

Write a Reply or Comment