job database transaction confirmation added