We have a nice piece of python that sends some emails and interacts with a cloud system. Works fine. But we have to fire it every few minutes to poll the db. We really need, for business purposes, to have the python script fire in real time, so there is no polling delay. (This serves sales people who are on the phone with customers.)
We really do not want a 1 minute polling loop. Or 30 seconds. We want the record to show in the db and for things to happen right away.
The fast way to make this fly is to have it fire when a specific record type is inserted into a table.
Can we fire a python script from a trigger?
Yes, per Aaron's note below, we know that this is a very bad thingTM, but this table gets very very little use (0-12 inserts a day). Polling the table fails to meet our business need (we need the .py to run immediately -- it does much more than send an email).
We believe a way to meet our business need is to set up the .net version of python on the sql server, and then have tsql call the python script the way it calls C# stuff... but we have no idea how to actually do this! (ergo this question)