Two database exist on two different SQL Server instances. They are linked servers, but they cannot communicate due to network issues.
Someone solves the network issues, and connectivity is restored. I want to run a stored procedure as soon as possible after connectivity has been restored. How can I accomplish that?