Sample Header Ad - 728x90

One step in Azure SQL job does not retry

0 votes
0 answers
61 views
I have an Azure SQL Database with a weekly maintenance job. The job scales the database up, performs various tasks, potentially including an index rebuild if fragmentation is high, and then scales the database down again. My issue is that, even though the 'scale-down' step of the job has 10 retries and a timeout of 12 hours configured, the step fails after 52 seconds, and doesn't retry. The step definition: retry_attempts = 10 An example execution: The step fails, with current_attempts = 1 It's a generic error, which is fine and expected: > Command failed: A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded. All other steps complete successfully - the 'scale-up' operation actually did need to retry before it succeeded, which is encouraging: The step succeeds, with current_attempts = 2 The error is the same as in the step which does not retry. If you have any insight into why a certain step would not retry, when others in the same job do, then I'd really appreciate it - the same issue seems to occur in every execution of the job! EDIT: It looks like markdown tables aren't supported here, swapped them out for screenshots.
Asked by yggdrasiljsp (1 rep)
Dec 4, 2024, 02:04 PM
Last activity: Dec 4, 2024, 02:09 PM