Name: SQL Server Agent status
Platform: Sqlserver
Category: Availability
Description: Checks if the SQL Server Agent is running.
Long description: This alert checks the master.dbo.sysprocesses table for the program_name value for the SQL Server Agent process. The program name value is controlled by the dbWatch parameter ‘sqlserver agent process name’. Besides this parameter values, the following program names are checked too: ‘SQLAgent – Generic Refresher’ and ‘SQLAgent – Job invocation engine’.
Version: 1.2
Default schedule: 0,15,30,45 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘1999’ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’ & eng_inst_priv = 0


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment