topic Re: Pause a failed task for some time period before kicking off again in Management & Governance

Pause a failed task for some time period before kicking off again

rittermd — Sun, 01 Nov 2020 15:40:49 GMT

I have a task that fails. It is set to retry a number of times. But the restarts happen immediately and the task ultimately fails.

Is there a way to say that if the task fails the first time wait 15 minutes before it tries again? If it fails again wait 15 minutes again and so on until it can actually run. The task fails because an upstream table is not available yet.

I saw something about a Pause task. But could not find a good example of how to actually do that.

Any guidance would be greatly appreciated.

Re: Pause a failed task for some time period before kicking off again

AndrewMcIlwrick — Sun, 01 Nov 2020 20:32:44 GMT

How about using a combination of ErrorLevel and the sleep script function ?

You can test if a statement works and not abort the script but go into a 15 minute sleep and then re-try. I have used somthing similar to this for "tempermental" rest services.

Basically control the behaviour inside your script and only go back to the task / QMC environment after a certain number of attempts. You do not want to have an infinite loop 😉

Re: Pause a failed task for some time period before kicking off again

Anders_Eriksson — Mon, 02 Nov 2020 07:51:00 GMT

Or simply start your load script with a 15 minute sleep and schedule the first run 15 minutes ahead of time. No nead for any error handling checking. Does not matter that the first run starts with a 15 minute sleep since the sleep should not put any load on the system.