Alert when data meeting condition

Hi, I’m new to PagerDuty and was told to first explore here when I was given the request.
Is it possible to send alert when certain condition is met in the dataset? For example, I have a table in SQL server which gets refreshed daily. One of the columns is number of overdue days. When the overdue days is 5 or 2, an alert to be sent to the email address in another column. Is this feature supported by PagerDuty? Any more details would be appreciated. :slightly_smiling_face:

You should be able to achieve this by defining conditions in the Global Event Rules or Event Orchestration, based on the event payload contents - incidents will then get created against a service if the condition is met. Refer to official documentation here for more detail https://support.pagerduty.com/docs/rulesets

Hi Eva!

As Chris mentioned, you can use Global Event Rules or Event Orchestration to detect conditions in the payload in order to trigger an incident. You can find more information in the link Chris shared as well as the Event Orchestration documentation:

https://support.pagerduty.com/docs/event-orchestration
https://support.pagerduty.com/docs/rulesets

Please also note that PagerDuty doesn’t detect conditions from your dataset in your SQL server, rather - you would need to send the events to PagerDuty and the conditions are detected from the incoming payload.

If your SQL server is able to send out emails, you can also use an email integration that will then trigger PagerDuty incidents. You can find the email integration guide here: https://support.pagerduty.com/docs/email-integration-guide

Also, please don’t hesitate to email us at support@pagerduty.com if you have any specific questions about your use case!

Thanks,

Qisthy Kodarusman