In 'Alarms by Time' the connection state bar is red when there are no red alarms
说明
A failed job causes a long red bar in the Alarm in the 'Alarms by Time' window. If you expand the alarms you can’t find the long red bar. The graphical layout is misleading.
解决办法
WORKAROUND: None.
STATUS: Issue resolved in Spotlight on SQL Server Enterprise v12, available here