public function getChildJobIdsByRootJobAndStatus(Job $rootJob, $status)
    {
        $qb = $this->createJobQueryBuilder('job');
        $rawChildJobIds = $qb
            ->select('job.id')
            ->where(
                $qb->expr()->andX(
                    'job.rootJob = :rootJob',
                    'job.status = :status'
                )
            )
            ->setParameters(
                new ArrayCollection(
                    [
                        new Parameter('rootJob', $rootJob),
                        new Parameter('status', $status),
                    ]
                )
            )
            ->getQuery()
            ->getScalarResult();

        return array_column($rawChildJobIds, 'id');
    }