>> I'm still trying to find out how to use Service Broker (SB) - I will see what I can find, but maybe you have time to explain me: <<
I would have to learn it first

There are more experienced people
on this newsgroup that can help you.
>> can I make some custom ordering of queue usage, e.g. handling requests from bosses is more important than standard requests (for now I use simple ordering on table column storing info about source of request)? <<
That is the idea of the priority number I showed you in my posting. A
worker can come into the queue with (priority = 100), middle
management can come into the queue with (priority = 50) and the
company president can start at (priority = 0). But the decrement
procedure will assure that every job eventually gets to (priority =
0), so nobody is live-locked.
I did an article decades ago for INFORMATION SYSTEMS NEWS when I had a
column on software Engineering about the different queue handling
methods; I compared them to traffic signals. I don't know if I have
an electronic copy of it, but it was funny and might help