DBSS Jobs Failed alarm is not fired when a job has multiple schedules
说明
A DBSS Jobs Failed alarm is not fired for a SQL Server job when there are multiple schedules (more than one "next run times") assigned to the alarm.
原因
DBSS_Agent_Job_List collections return duplicate rows for job with multiple schedules. As a result the failed job alarm is not fired because the mechanism expects a unique row per job in the topology.
解决办法
WORKAROUND
Remove one or more schedules to reduce the number of schedules for the job to one.
STATUS
This issue was logged as defect FOG-5508 and has been fixed in the 6.3.0.10 and higher releases of the SQL Server cartridge.