We have another vendor on a project where we have to send requests via a SQL table and then monitor their response table for status of the requests. I’d like to set this up in the most efficient and manageable way possible. I could “brute force” it by having a script that issues the requests (based on a PLC trigger) and then sits in a “loop”, periodically “waking up” to test for the response. This methodology is usually not the best form nor most efficient.
The insert into the request table will return the Unique ID of the newly inserted record. The response record will contain that Request ID as part of its response record. So what I would be looking for is a new record added that has that ID and then examine the status filed to find out if the request was successful or if there was an error.
The request record is easy enough to insert. Is there more efficient method than my “brute force” method to monitor for the response data?