marrowyung
asked on
MS SQL jobs with email alert
hi,
I'd like to build SQL jobs alert , as long as a SQL jobs failed it will email me, without monitoring tools, usually how can we do it ? by using SQL jobs steps order?
I'd like to build SQL jobs alert , as long as a SQL jobs failed it will email me, without monitoring tools, usually how can we do it ? by using SQL jobs steps order?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
1. Enable Database Mail to use SMTP:
https://www.mssqltips.com/sqlservertip/1100/setting-up-database-mail-for-sql-server/
2. Add Mail Operators:
https://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/
3. Set SQL Job notification on failure:
https://www.brentozar.com/blitz/setting-failure-emails-on-jobs/