Looks like the nightly job failed because the approved table has a trigger to rollback my update ;-)