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
Store

DPA and Job monitoring

I come for a Quest Spotlight background. My new company is using DPA and tool work well for performance analysis.

My question is, Is there a way to see when jobs failed using DPA or is this more of a Application Monitor type of feature?

Find more posts tagged with

Accepted answers

All comments

darichar

Yes, a Database Job Failure alert can be configured. To do that, click on Alerts and go to the Manage Alerts tab. Choose the Administrative option and select the SQL Server Job Failure alert and configure as needed.

edycus

Can I limit it down to just the backup jobs I care about?

darichar

You can do that by using a custom alert referenced in this Thwack article: Job Failure

In the SQL statement, you can add something like this to the WHERE clause to limit the alert to specific jobs:

AND t2.name IN ('Backups - PROD', 'Backups - DEV')

Note: The #FREQUENCY# is placeholder that DPA substitutes the alert execution frequency value, e.g. if the alert executes every 10 minutes, it will substitute 10 and cause the query to look back 10 minutes for job history.