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

Alerts in solarwinds

How to send email alert if query running greater than 15 minutes,Session more than 24 hours and job greater than 1 hour??

Find more posts tagged with

Accepted answers

aLTeReGo

Those would be three different alerts. Below are two examples.

SQL Query Longer than 15min.

SQL Agent Job Duration

Agent Job Duration.png

All comments

mrs.alterego

This is more of a Orion Core question, but I'm moving this to the NPM forum since I know many of the Core team watches that forum.

Jan_Pelousek

To me it looks like alerting on data polled by SAM (if they do). Core part on that is just the engine part (evaluation if condition is true or false). So SAM space will be better place IMO

mrs.alterego

Thanks Jan! I've moved this to the SAM forum, per your suggestion!! :-D

aLTeReGo

Those would be three different alerts. Below are two examples.

SQL Query Longer than 15min.

SQL Agent Job Duration

Agent Job Duration.png

nk1

Thank you.But i am getting the alert as "Alert ${N=SwisEntity;M=ComponentAlert.ComponentName} is down on ${N=SwisEntity;M=Application.Node.Caption}"

How can I get like 'Server name/Database name and query name'??

aLTeReGo

You can use the Macro browser to add the appropriate dynamic value(s) related to the item that triggered the alert as part of the Trigger Action.

Variables in Messages.png

nk1

I am receiving the email alerts on the next day of the issue raised.

Can you please suggest some solution...