sql server - How to query Alert System Enable mail profile properties - Stack Overflow
In order to send automated job failure notifications from SQL Server Agent, you must configure Database Mail and then to to SQL Agent properties > Alert System > Mail ......