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

Invoke Sql Agent Job

Is it possible to invoke a sql agent job based on an alert? I'm am trying to start a job if the current response time is greater than a particular threshold.

Thanks

Find more posts tagged with

Accepted answers

ecklerwr1

How do you usually invoke this sql agent job? Can you execute if from the command line or from a vbscript? If so they you could setup an advanced alert trigger action to run your job when a node response time is greater some value. You set this up in the Advanced Alert Manager.

All comments

mrxinu

Why not use the 'External Application' alert action to call osql to run the stored procedure?

ecklerwr1

mrxinu

How do you usually invoke this sql agent job? Can you execute if from the command line or from a vbscript? If so they you could setup an advanced alert trigger action to run your job when a node response time is greater some value. You set this up in the Advanced Alert Manager.

Isn't that what I just said? Madness I tell you!