The SQL Agent - Jobs Failed alarm is raised when Spotlight Enterprise detects that at least one SQL Agent job has failed in the last few minutes.
Edit me

When the alarm is raised, open the SQL Server | Support Services drilldown | SQL Agent Jobs page for information on SQL Agent jobs. 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.

Spotlight collects data on failed jobs from the SQL Server instance periodically (every 5 minutes by default). This alarm will report on all failed jobs since the last data collection. You can configure data collection schedules from the Spotlight Client, Configure | Scheduling.