In Business Central, there is already a standard feature called Maximum No. of Attempts to Run, where you can specify the maximum number of attempts. Business Central will automatically retry the Job Queue if it fails.
and if you want to use Automate there is a trigger called When a business event occurs where you can Select event shown below and try again.
Hope this helps resolve your issue.
If this solution was helpful, please consider marking it as Verified Answer.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.