Timeline for Is there a better way to trigger API calls from an on Prem SQL Server without using a job scheduler?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 3, 2023 at 23:35 | comment | added | J_H | Ensure that INSERT / UPDATE produces a timestamped row, with an index on that timestamp. Then have a python cron job poll with cheap "give me the most recent row" queries, and run the required job when it notices the result has changed. | |
| Feb 3, 2023 at 23:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 4, 2023 at 21:41 | answer | added | zfou | timeline score: 1 | |
| Jan 4, 2023 at 13:27 | answer | added | Ewan | timeline score: 0 | |
| Jan 3, 2023 at 19:33 | comment | added | Ben Cottrell |
It seems that sp_execute_external_script is likely the feature or SQL Server that'd most closely match this - learn.microsoft.com/en-us/sql/machine-learning/tutorials/… - perhaps along with ordinary database triggers?
|
|
| Jan 3, 2023 at 1:17 | review | Close votes | |||
| Jan 17, 2023 at 3:06 | |||||
| S Jan 2, 2023 at 22:29 | review | First questions | |||
| Jan 3, 2023 at 8:30 | |||||
| S Jan 2, 2023 at 22:29 | history | asked | hnewbie | CC BY-SA 4.0 |