(Design Idea) Best practice for backup recording for multi-process workflow engine

Question

I am developing several processes to request a job from a database.

Each task is woken up once a minute to request a task and send it to the document management system.

I need advice on what is the best way to mask a record and request it, rather than duplicating it with another process.

Answer 1

In Oracle, depending on the version:

10g and down - use the extended queue. Delete your work with the keys that you left in the queue.

11g - , SKIP LOCKED SELECT FOR UPDATE , ; , PL/SQL.

Answer 2

, , - ? "/", (?). , , , "" /. .