On 4 Mar, 19:25, B D Jensen <bjorn.d.jen...@gmail.com> wrote:
> Hi!
> 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.
>
> Best regards
> Bjorn

Have you considered using Service Broker?
http://msdn2.microsoft.com/en-us/library/ms166043.aspx

--
David Portas