Hello Team,
We are looking for a possible solution for SQL agent job failures from one centralized server which gives us the report for the status of failed jobs say for past 3 hours on X database servers.
From each server i have found a way but that throws back lot of emails for X server:
The possible solution i found over the net was Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise, but this has drawback that whenever server reboots, the query written on tempdb at repository gets cleared as new tempdb gets created.
We have free tools like Idera SQL job manager and SQLVIBS but due to security reasons i am not allowed to install them.
Please suggest for any other possible solution which alerts a report for failed sql agent jobs via one email for all my X DB servers.
Thanks!