I'm working on a script that load data from a sql server database through a vpn connection (slow). Many times the connection fails after one or two table loads. Is it possible to script in a way that if one table load fails it will retry to load automatically from that point (and I wouldn't have to reload the whole thing?)?
Too much script needed to build up. But, to thought you can call "Audit logs" or script logs from failed point.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
I wrote such a script but that works within our framework. There is a max retry parameter (so that no infinite loop) in a config file and a log is generated in qvd every time it fails. Not too hard to build if you play wih the errormode.
