Would sql deadlock cause job to hang