• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Job Duration Monitor

  • ID:  Microsoft.SQLServer.2012.AgentJob.JobDuration
  • Description:  Monitors Agent Job Duration. Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object.
  • Target:  SQL Server 2012 Agent Job
  • Enabled:  Yes

Operational States

Name State Description
The job's duration was over the upper threshold Success  
The job's duration was between the lower and upper threshold Warning  
The job's duration was below the lower threshold Error  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 600 This monitor uses a script to perform its monitoring of long running jobs. This is the interval (in seconds) between executions of that script.
Synchronization Time   The synchronization time specified by using a 24-hour format. May be omitted.
Lower Threshold (minutes) 60 The lower threshold (in minutes) for this monitor. By default, exceeding this threshold will result in the monitor changing to at least a warning state.
Upper Threshold (minutes) 120 The upper threshold (in minutes) for this monitor. By default, exceeding this threshold will result in the monitor changing to a critical state. Being between this threshold and the lower threshold (inclusive) will result (by default) in the monitor being in a warning state.
Timeout (seconds) 300 Specifies the time the workflow is allowed to run before being closed and marked as failed.

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

SQL 2012 Agent Job Duration Monitor. Monitors Agent Job Duration.

Causes
This unit monitor does not contain any causes.
Resolutions
This unit monitor does not contain any resolutions.
External References
This monitor does not contain any external references.

See Also for SQL Server 2012 Management Pack


Downloads for SQL Server 2012 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED