Goal: Replacement of SMTP messaging (DBMAIL) with webhooks
Is it possible to send an alert from SQL Server to PagerDuty without using CLR?
Goal: Replacement of SMTP messaging (DBMAIL) with webhooks
Is it possible to send an alert from SQL Server to PagerDuty without using CLR?
Hi
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:
Example workflow:
curl
/Invoke-WebRequest
to call the Rundeck API and trigger a specific job.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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.