What approaches have you all out there used to solve the classic Queuing problem that you get often in OLTP applications. I am aware of Advanced Queuing on Oracle but would like to here of a Foxpro solution.

Here is the scenario.

I have a PrintJob Queue where jobs are entered it has fields:
SUBDATE - Time Submitted
RECNO - Sequencial (identity type field)
JOBINFO - Info about the specific job
PROCESSED - 0-new 1-processing 2-done ok 3-done error

So many jobs could be submitted by various applications and the same time
also many applications can be processing the jobs in correct time , sequence.

What's the best way to ensure that the records are processed by one and only one server at the same time?


BR
Tim