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

[rittermd]

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.

[AndrewMcIlwrick]

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 😉

[anderseriksson]

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.