Re: Queue handling design pattern? Hi Joe!
I now looked a little more at SB, it seems a bit complex for this type
for this purpose (=> much more code than I had written in my
solution)...
.... but I probably should read more so I fully understand what it can
give...
I looked also at your select statement picking job to do, but my
problem is not to find out wich
job to process. I have 8 scheduled jobs. Each job/queue has its "own"
rows to process, but since some reports are faster than others, some
jobs will be delayed, while not all queues have something to do after
a while.
The reason why each row is related to a specifik job/queue is to
ensure, that only one single jobs tries to handle the request (row).
And I also like to see which job is processing which row, so I can
stop the right job,
if I need to stop processing manually because it tooks too long.
Thank you for your ideas ;-)
Best Regards
Bjorn |