Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

SQL Agent - Long Running Jobs Alarms

A SQL Agent - Long Running Jobs alarm is raised when a SQL Agent job has been running for considerably longer than expected.

There are two independent but related SQL Agent - Long Running Jobs alarms. The Long Running Jobs (Percent) alarm is enabled by default and adequate for most environments. The Long Running Jobs (Time) alarm is disabled by default. Although it is possible to enable both these alarms together, usually you would enable one for your environment and disable the other.

Alarm Description

SQL Agent - Long Running Jobs (Percent)

The SQL Agent - Long Running Jobs (Percent) Alarm is enabled by default. The default threshold for this alarm is 200% of the average run time for SQL Agent jobs of its type. Use this alarm to set thresholds in comparison to other jobs of its type.

SQL Agent - Long Running Jobs (Time)

The SQL Agent - Long Running Jobs (Time) Alarm is disabled by default. The default threshold for this alarm is 600 seconds. Use this alarm to set thresholds against absolute time.

When the alarm is raised

Configuration

These alarms can be configured for your environment. For more information, see Configure | Alarms.

  • Adjust the Severity Table to customize the thresholds for each severity.
  • A SQL Agent job may require a specialized severity table. Select a SQL Agent job from the Key Value list then set the Severity Table for that key value (SQL Agent job). For more information, see Configure an alarm.
  • Exclude certain SQL Agent jobs from this alarm. This alarm will never be raised against excluded SQL Agent jobs, no matter how long they run for. See Do not alarm for certain values for more information.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating