[scheduler] Fix deadlock in PG backend for repack

Description

Adding FOR UPDATE SKIP LOCKED to repack retrieve job transformation DB query to fix a deadlock.

Checklist

• Documentation reflects the changes made.
• Merge Request title is clear, concise, and suitable as a changelog entry. See our contributing docs

References

Closes #1427 (closed)