The SQL Agent - Jobs Failed Alarm alarm is activated when Spotlight on SQL Server detects that at least one SQL Agent job has failed in the last few minutes.
When this alarm is current, you should:
View the SQL Agent Jobs page, on the Support Services drilldown, to determine which jobs have failed recently. You can double click any job to view the messages that it logged during its last run. This page shows the last run time and completion status of each job, as well as a graph showing which jobs ran recently, and the completion status for each run.
