Hi

Looking for a good practice to share a task across 3 machines.

The same process is running on 3 separate machine and each process should get the tasks in batches of 20 items from a SQL server table, process each, and mark the record as done when completed.

No duplication allowed.

What's normally done to achieve this ?

TIA
John Harriss