Note: Make sure email profile and account are setup on the SQL Server first.

To enable SQL Server Agent job email notification go to …

SQL Server Agent -> Properties -> Alert System -> Mail session -> Enable mail profile

Last modified: November 18, 2020

Author

Comments

Write a Reply or Comment