How do I create a script which retries to connect to SQL?

PowerOx327

Hi,

 

The database which I am using is very unstable, so it fails a lot mid-way when tries to connect to SQL. How do I script it so that when it fails, it retries unitil it connects or until a maximum of five times.

 

Thanks.

tsl

You might be able to use the LogCapture() function which allows you capture messages sent back to the JMP log by function calls.

Something like this :

RetryCount = 0
ErrMsg = LogCapture(<your SQL connection string>);
while( contains(ErrMsg, <some error string you're looking for>) & RetryCount < 5,
++RetryCount;
ErrMsg = LogCapture(<your SQL connection string>);
)