Does using Retry attempt option SQL Agent job create performance issue I want to use Retry attempt option of sql agent job, want to know does it hold the resource and will create performance issue, if i keep it every 60 minutes
The retry process itself does not use resources: it basically idles for the specified amount of time, then restarts the step. The step itself uses resources.