No. The retry option only affects the alarm SQL Server connection failure.
To achieve this for the SQL Server Secondary failure, it's possible to create an alarm action like below to
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center