add test to cold-restart a previously failed job execution, and related changes to JobOperatorImpl and sql to make it work.