This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How can I send message to MS Teams through SQL Server?
Example: in case of an error in a Job-Agent, SQL Server sends an alert message in a Teams group
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Hi @Nguyen Tu
Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. Since your question is related to SQL Server, which is not in our support scope. I will remove teams tag from your thread. Thanks for your understanding!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
you would use the teams rest api:
https://learn.microsoft.com/en-us/graph/api/chatmessage-post?view=graph-rest-1.0&tabs=http
use the failure flow or add addition notifications:
https://www.sqlshack.com/reporting-and-alerting-on-job-failure-in-sql-server/
Many thanks @Bruce Aitken
With Microsoft Graph I was able to send the alert message to a group in Teams.
It was necessary to install the Graph module on the server to send the message.
link: https://learn.microsoft.com/pt-br/graph/api/chat-post-messages?view=graph-rest-1.0&tabs=http