Here's the gist. I have tasks scheduled every morning at let's say 7:00am. But they will fail sometimes if that database is still in a restore so I might not be able to actually successfully execute the tasks until 7:30am or 8:00am or even 8:30 etc. Instead of me watching it like a hawk, is there a workaround for a task, upon failure, to retry again after a delay (let's say 30 min) until successful?
Or, instead of "until successful" loop, I could specify the max number of retries? (Not to be confused with the task session timeout which instantly retries without any delay)