SQL probe agent_job_failure not creating an alert in USM under any severity setting


Article ID: 103959


Updated On:


NIMSOFT PROBES DX Infrastructure Management


The sqlserver probe will not generate an alarm for agent_job_failure checkpoint in USM under any severity setting.


- Working as designed, see KB Article:

How does the sqlserver "agent_job_failure" checkpoint work?



- UIM 8.51
- sqlserver (any version)


Customer decided to use an alternative to alarm on sqlserver agent job failures.

Since SQL job failures write an event ID 208 to the application file, the customer chose to setup the ntevl probe for the applicable devices with the specific criteria/messages for each job they needed to alert on. This is an excellent and very straightforward alternative and you can use the ntevl probe profiles to alarm on individual job failures and their associated alarm messages,.

Event ID: 208 Source: SQLSERVERAGENT

Description (example)
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan '<name of job>' (0xF673402DE6B2F14A9C671B08202C92E2) - Status: Failed - Invoked on: 7/10/2001 12:15:00 AM - Message: The job failed. Unable to determine if the owner (<username>) of job DB Backup Job for DB <name of job>' has server access (reason: Could not obtain information about Windows NT group/user '<name of user>'. [SQLSTATE 42000] (Error 8198)).