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

[#1]

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.

[#2 · Accepted solution]

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>);
)