Consume jobs from dead and retry queues

What does this MR do?

Allow steal to also look in the dead and retry queues.

This is helpful to recover background data migrations.

Backport of https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/9267

What are the relevant issue numbers?

https://gitlab.com/gitlab-org/gitlab-ee/issues/9518

Does this MR meet the acceptance criteria?

• Tests added for this feature/bug
• Conforms to the code review guidelines
• Conforms to the merge request performance guidelines
• Conforms to the style guides
• Conforms to the database guides
• Link to e2e tests MR added if this MR has Requires e2e tests label. See the Test Planning Process.
• Security reports checked/validated by reviewer