Hi ​@MadMax,

I think you can use Rundeck to accomplish this at scale, or just use SQL Server Agent w/ an external script if your setup is simple and not resource intensive.

How it works with Rundeck:

• You can set up a Rundeck job that is triggered by a SQL Server event (for example, via a scheduled check, a file drop, or a custom integration).
• The Rundeck job can run a script (PowerShell, Python, Bash, etc.) that sends a webhook to PagerDuty using the Events API.
• You can even have SQL Server Agent call Rundeck’s API to trigger a job when a specific alert condition is met.

Example workflow:

1. SQL Server detects an alert condition.
2. SQL Server Agent runs a command-line script or uses curl/Invoke-WebRequest to call the Rundeck API and trigger a specific job.
3. The Rundeck job sends the PagerDuty webhook.

I've added links to docs above so you can have an easier time figuring out. Please let me know if it works and have a nice day!

Hi @lupimiquel

Thanks for your response.

I am trying to pass a sql command’s results into the @html_details part of the payload as shown below.

Please send an example of the code required in sql as a select command which will pass into the @html_details field of this payload which then is sent to pagerduty: 

"routing_key": "' + @routing_key + '",
        "event_action": "' + @event_action + '",
        "dedup_key": "' + @dedup_key + '",
        "payload": {
            "summary": "' + @summary + '",
            "source": "' + @source + '",
            "severity": "' + @severity + '",
            "custom_details": {
                "HTML": "' + @html_details + '"