Dear All,
I have several Servers and I have downloaded all files from all servers.
sometimes, one of servers doesn't work properly and the ETL is unable to download files from the faulty server. So, ETL stops and it must be run manually again.
I would like to add intelligence to it so that it skips the faulty server without crashing. Do you have any idea How can I set my ETL to check the server's status. If I know the server status, I can skip it if faulty. For example, if server 3 has a problem, my ETL will be able to jump from 2 to 4 for download files instead of crashing at server 3.
Can anybody help me that how to catch errors and exceptions and show meaningful messages.Thanks