Return
-
Title
Spotlight does not trigger alarm on SQL agent failed jobs. -
Description
User sees SQL agent jobs fail in SQL Server instance, howeverm Spotlight is not reporting these jobs not reported in alarm log. There are no alarms raised for these failed jobs. -
Cause
One of the jobs has a finished time in the future -
Resolution
Backup {DS}\conf\PACKAGE\sqlserver_spotlight\2005\QS_AgentJobsFailed.sql file to a different location. Copy attached SQL file to the same folder.
Where {DS} is Diagnostic Server installation folder.
-
Defect ID
PATCH -
Attachments