Search code examples
azureprocessautomationazure-sql-databaserunbook

Exceed 3 hours timeout Automation Runbook Azure

Hello guys,

I have a runbook to launch but it takes more than 3 hours to run (process of partitions) and so, it stops before being complete. I wanted to know if there is a way to exceed the 3 hours limitation. I've heared about hybrid runbooks but I'm not sure how it could solve my problem. Do you know if there is other solutions ?

Thanks a lot.

Solution

  • If you want to stick to Azure Automation, you can use Checkpoints:

    Azure Automation has a feature called “fairshare”, where any runbook that runs for 3 hours is unloaded to allow other runbooks to run. Eventually, the unloaded runbook will be reloaded, and when it is it will resume execution from the last checkpoint taken in the runbook. Thus, in order to guarantee that the runbook will eventually complete, you must add checkpoints at intervals that run for less than 3 hours.

    Source.

    Here is an example: