• Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

Job Duration Monitor

  • ID:  Microsoft.SQLServer.2008.AgentJob.JobDuration
  • Description:  Monitors Agent Job Duration.
  • Target:  SQL 2008 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 (sec) 600 This monitor uses a script to perform it's monitoring of long running jobs. This is the interval (in seconds) between executions of that script.
Synchronization Time    
Lower Threshold (min) 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 (min) 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 (sec) 300 the amount of time (in seconds) that the script is allowed to run.

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

SQL 2008 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 Management Pack


Downloads for SQL Server 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