Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SQL Job Failure Alert Issue in DPA

We have configured a SQL Job Failure alert in DPA, but it is currently triggering alerts every day for jobs that are not running. The expected behavior is for the alert to trigger only when a SQL job actually fails, and it should not send notifications continuously.

The alert should notify only when the job status changes to Failed, based on the previous execution status. Once a failure alert is generated, it should not trigger again on subsequent days simply because the job has not run for multiple days.

Has anyone successfully configured SQL Job Failure and SQL Long‑Running Job alerts in DPA to work as expected under this requirement?

Find more posts tagged with

Comments

fabian.s

Maybe I'm wrong but is this not exactly what the notification policy "Notify when level not visited since normal" is covering?

When the job is running ok → status normal → no notification

When the job fails → status high → notification

When the job fails → status high → no notification

https://documentation.solarwinds.com/en_vers/success_center/dpa/2024-2/content/dpa-notification-policy-for-alerts.htm

darichar

Check out this custom alert for DPA: https://thwack.solarwinds.com/kb/articles/3903-sql-server-job-failure. The trick is this alert returns the status of all jobs every time and then when it changes (success then fail or fail then success), it will alert.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of