B D Jensen (bjorn.d.jensen@gmail.com) writes:
> I'm looking for other good ideas how to implement an queue where
> multiple jobs.
>
> For now I have a single table with identity column and some information
> about what to do. Combined with multiple jobs "eating" from queue, e.g.
> they take specific rows for that job corresponding to id % #queue
> (modulus).
>
> But each jobs take different time, so I see often that only half of
> queues running while long running jobs blocks for run of waiting jobs.

THe unavoidable question is: what's wrong with Service Broker?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx