Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
SQL agent job failure not generating notification email
설명
Notification emails not sending the alert for SQL agent job failures.
원인
SQL Server connections have been disabled on SQL agent job failed collection for background schedule.
If the background schedule of SQL agent job failed collection is disabled, then the collection will not run and the agent job failure alarm will never be raised.
해결 방안
To receive SQL agent job failure alert:
1. Go to Configure | Scheduling and select the problematic SQL Server connection
2. Select "SQL Agent Job Status" collection and check "Collect data when Spotlight is not connected" checkbox
