Hi Mat,
There is no option for re-running tasks automatically. Some Community members already requested such an option.
Just a few ideas:
If your tables are simple, you can have a universal re-usable module for querying a database table which name and connector are specified using parameters. In this case, you call a module, pass it a connector name and a table name, and the module returns the table and does re-tries if necessary.
Using the "Repeat" action looks right here. Alternatively, you can just call Module Y three times (once per each retry) instead of using "Repeat". Between the retries, use the "Skip" action to skip further retries if a call was successful.