I would always recommend an enterprise monitoring solution for your important SQL Servers. There may be some that are less important though. You can always configure alerts at an individual job level, you can create triggers or extended events to notify you, or even use base alerts in SQL Server. If you need a quick and dirty solution to throw into place temporarily though, I like this option.
Continue reading “Alert when SQL Server jobs fail”
Skip to content
Jon Shaulis – Data Professional
SELECT Knowledge FROM Internet WHERE Topic = 'Data';