Hi - We are interested in writing the output status into a sql server table. For example - there would be say 20 bots performing an invoice processing process. we need to capture information like
- Transaction Start/End Time
- Completion Status
- Failure Message
for all the 20 bots (may be 100 records each per day) into sql server.
What is the best way to do this? Will it be a problem if 20 bots try to write and there might be a deadlock and thus delay in bot execution?
Any other option like, bots updating a text file or some sort & have another bot just to write into the DB?
Share your thoughts & best practices