Jobs without notification

Install metric...

Metrics install automatically if you have SQL Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.

SQL Agent can be configure to notify an operator when a job fails. While failed jobs also surface in the monitoring, proactive notification often allows for a quicker response.

Metric definition

Name

Jobs without notification

Description

SQL Agent can be configure to notify an operator when a job fails. While failed jobs also surface in the monitoring, proactive notification often allows for a quicker response.

The T-SQL query that will collect data

Instances to collect from

Select all

Databases to collect from

MSDB only

Collection frequency

1 day

Use collected or calculated values

Leave the Use a calculated rate of change between collections check box unchecked

Metric collection

Enabled

Alert definition

Alert name

Jobs without notification

Description

One or more SQL Agent jobs do not have notification enabled

Raise an alert when the metric value goes

above the defined threshholds

Default threshold values

High:
Medium:
Low:0

Raise an alert when the threshold is passed for

collections

Alert is

Enabled