We are going to start a new project. The requirement is to Get the data from 4 databases by executing a stored procedure. We have the same data in all the databases and the SP is also present there. Since the credentials used to execute the SP is different,
i am going to call the SP 4 times from the application and will merge the data. But if the processing fails or hangs, i want to exeute the same process again. This can be a windows/console application and i will schedule this in the windows task scheduler
to execute as a job. So no user interaction will be there. The question here is how do i re-run this application if an exception occurs.? Is it a good oractice to use Thereading for this purpose?
View Complete Post