Job.update_all({state: 'Failed'}, ['state is null and success = ?', false])
Job.update_all({state: 'Complete'}, ['state is null and success = ?', true])
Job.update_all({state: 'Running'}, ['state is null and running = ?', true])
Job.update_all({state: 'Failed'}, ['state is null and success = ?', false])
Job.update_all({state: 'Complete'}, ['state is null and success = ?', true])
Job.update_all({state: 'Running'}, ['state is null and running = ?', true])