Better separation of concerns for db and business logics

[heemankv]

You are correct, but I mean to inform that we have another fn that could potentially do the same thing this function is performing get_jobs_by_types_and_statuses

Originally posted by @heemankv in #773 (comment)

[heemankv]

Status update from codebase review on 2026-05-05.

Classification: Still relevant.

Current state:
Still relevant. The orchestrator still mixes DB, queue, and business logic in the same services and handlers.

Keeping this issue open based on the current tree.

[github-actions]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a 👍
Because this issue is marked as stale, it will be closed and locked in 7 days if no further activity occurs.
Thank you for your contributions!