A third-party application uses MS SQL Server as the data store. In the 3rd-party application API, they forgot to add webhooks for events so I'm trying to add the concept of webhooks in their API by adding a relevant table trigger on their SQL Server database.
The idea is to capture UPDATE events with a table trigger and, if they change a given field, then notify a process (outside the SQL Server box) to perform some batch actions.
I was thinking about having SQL Server somehow calling a URL (aka the "webhook") without waiting for a response (or timing out immediately), preferably with T-SQL.
Is there any way to do that in SQL Server (asyncronous URL call from T-SQL) or the only safe way to communicate with external systems without the risk of accidentally locking up SQL Server is to send an email from SQL Server? (I'm using SQL Server 2012)