SQL Agent Hung Jobs (SQLAgentHungJobs)
Reports the number of the hung jobs in the SQL Server Agent. Hung job is considered as a job which one of its steps ran longer than 'SQL Agent hung jobs' configuration which is defined in the time based parameters section and it can be configured by the user.
Generates annotation - ✅️
BMC PATROL properties
Property | Default value |
|---|---|
Application class | MSSQL_SERVER_AGENT_HEALTH |
Command type | NA |
Platform | All |
Icon style | Graph |
Unit | Number (#) |
Border range | Undefined |
Alarm1 range | Undefined |
Alarm2 range | Undefined |
Scheduling (poll time) | Inherited |
Active at installation | Yes |
Parameter type | Consumer |
TrueSight/
BMC Helix Operations Management
properties
Property | Default value |
|---|---|
Monitor type | MS SQL Server Agent Health |
Key Performance Indicator | No |
Monitor for abnormalities | No |
Graph by default | No |
Availability | No |
Response time | No |
Normal distribution | No |
Statistical | No |