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

SQL Server Agent Windows Service Monitor

  • ID:  Microsoft.SQLServer.2008.Agent.ServiceMonitor
  • Description:  This monitor checks the status of the SQL Agent service for this instance of SQL Server.
  • Target:  SQL 2008 Agent
  • Enabled:  Yes

Operational States

Name State Description
Windows Service Running Success  
Windows Service Not Running Error  

Overridable Parameters

Parameter Name Default Value Description Override
Alert only if service startup type is automatic true This may only be set to 'true' or 'false'. If set to 'false', then alerts will be triggered no matter what the startup type is set to. Default is 'true'.

Alert Details

Monitor State Message Priority Severity Auto Resolution
Windows Service Not Running (Error) SQL Server Agent Windows Stopped Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

This monitor checks the status of the SQL Agent service for this instance of SQL Server. State will change to an Error state and an alert generated when the service is not running.

If the SQL Agent service is configured to be disabled, no state change or alert will be generated.

Causes

A service can stop for many reasons, including:

  • The service was stopped by an administrator.

  • The service was prevented from starting because the user account could not be authenticated.

  • The service encountered an exception that stopped the service.

  • The service was improperly configured, which prevented it from starting.

  • Another service (e.g. SQL Server) that this service is dependent on was stopped

Resolutions

You can attempt to restart the Windows service for the SQL agent by using the following link:

Start SQL Agent service

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