Based on documentation:
Number of Attempts on Failure: Maximum number of consecutive execution attempts for one iteration.
So you should be able to control the number of retries of failed executions with it and AFAIK it should work. I think you should post this question to the ODI forum to get experts on ODI to comment on this.
Fusion Applications Developer Relations