my problem is that in sql server i have a table which people can request what type of house they want to buy. in other hand, there's other table for my different defined houses which people want to sell.
the question is that how can i create something like an automatic robot or crawler in sql server to compare each row from requested table to houses table to find matched cases and then send results to web api and then sending SMS to the buyer. i want this process to be run automatically.
in addition users are working with database in different ways (logins, filtering tables, logging, inserting and so on) and i don't want to have a low performance in this senario while automatic robot works beside typical database queries and procedures. i really don't know what kind of technology it does need.
Aucun commentaire:
Enregistrer un commentaire