This metric investigates backup jobs, searching for any that may be disabled inappropriately.
If any of your backup jobs have been disabled inappropriately, you may not be aware of their state. This may cause you grief if backups do not occur properly. Ensuring that your backup jobs are functioning as desired is paramount. Monitoring them is vital to the health of your topology.
The alert associated with this metric will keep a vigilant eye on your systems, ensuring that the appropriate jobs remain in an enabled state, allowing their functionality to continue executing properly.
Note: This query looks for jobs with ‘backup’ in the name. It also excludes specific jobs that are acceptable to be disabled. Enter your own values here as you see fit.
Note: This metric works on SQL Server 2000 SP4 and later versions.Disabled backup jobs,