Need some of your suggestions : -
Requirement - In a DB, i have multiple records(eg. multiple policies), i want those policies to be processed by distributing the policies to multiple Robots without any deadlock or duplicate creations. i dont have orchestrator so i cannot use queue transactions for this. All i have is a DB and multiple machines in a same network which can run the Robots.
I got to know that stored procedures would work here but not sure how to do that.
please drop your valuable suggestions.