Thanks for the reply,

We know the causes for which the works fail randomly, and as I say, it is due to connectivity problems of our SQL servers. In addition, these works are launched at dawn to collect information for a scorecard.