SQL Agent Jobs that are cancelled are not label failed. Spotlight will not be able to detect it as a failed job and hence will not alert them.
解决办法
The SQL Agent Job history will have comments indicating if a job is cancelled or failed. Enhancement request has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
