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

PowerOx327 — Fri, 09 Jun 2023 17:08:41 GMT

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.

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

tsl — Tue, 30 Aug 2022 06:02:37 GMT

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

topic Re: How do I create a script which retries to connect to SQL? in Discussions

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

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