Friday, March 23, 2012

job retry

I have a step in a job that is set to retry on failure. Last night we made a change to a store procedure before the step failed. The retry started about 20 minutes after the update of the stored procedure. Will SQL Server use the updated version stored procedure on the retry?Yes, it will. Once you update a sproc, any subsequent calls to that procedure after it has been changed will invoke the new procedure version.|||Thank you.

No comments:

Post a Comment