I've created jobs with multiple steps that run a stored procedure for different variables. For each step, I've set retry attempts to 10 with 1 minute intervals. I've noticed that even though a step successfully completes the stored procedure, it will still go ahead and retry the step 10 times before going to the next step. What can I do to stop this from happening, short of removing the retry attempts? Thank you for your help.
I could remove the retry attempts but want to know what other mitigations I can apply to ensure that the job step doesn't repeat itself despite being successful.