We have nearly 30-40 different servers and would like to create alert for jobs that are disabled.
Need to create alert that will find jobs that are disabled that are not already listed in a table that contains "known disabled" jobs for each server. Steps would be;
We are planning to create table on development server and pushed into all other servers using SSIS package.
-Create table
-Populate with all jobs and job statuses
-Verify that all jobs that are disabled should be with the team
-Add this table to the SSIS package that pushes data out to the database on all servers
-Create an alert that will run and check for jobs that are disabled that are not listed as disabled in the table.
Any help would be greatly appreciated.