Failed SQL Agent jobs are not seen in the View: Failed SQL Agent Jobs while they are seen in the Server Alarm Report (4229327)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Failed SQL Agent jobs are not seen in the View: Failed SQL Agent Jobs while they are seen in the Server Alarm Report
Description

Running the Report | Server Alarm Report, all failed SQL Agent jobs can be seen in the report.
However looking at the same time frame for the same failed jobs in the View | SQL Server Operations | Failed SQL Agent Jobs of the Spotlight GUI, they do not show up at all.
Cause

Data collection method for Server Alarm Report vs Failed SQL Agent Jobs view are different.
Resolution

WORKAROUND:
None.
STATUS:
Waiting for a fix in a future release of Spotlight on SQL Server Enterprise.
Defect ID

SOSSE-6042

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title