This is probably easy, but I can't find it mentioned....
Anyway, I need to connect to our SQL estate via a remote SQLSMS connection which seems to have a shortish time-out that is irritating, as its a lengthy process signing-in again.
I have a select script that I like to check through the day. Is there any way to avoid the time-outs by running this script repeatedly, at say a 5 minute interval to display the results on screen? Even better would be if I could also specify a finish time so that it will say not execute beyond 5pm.
Sound like it should be do-able, right - begin/wait/loop etc??