Get Failed Jobs with T-SQL

Geschrieben von Database Magician am Freitag, 12. August 2016

'Monitoring SQL Jobs can be done in many ways, and I highly suggest your jobs send an email notification to your DBA group on failure. No not just you. What happens when you are on vacation or you leave permanently and your account gets disabled? No notifications. Don’t do that. You can also set up fancy reports to display information about your job status using SSRS, but I always like to have something that is easily portable and can be ran in SSMS quickly.'...

https://sqlsanctum.wordpress.com/2016/03/25/get-failed-jobs-tsql-script/