Business process hangs

I have a business process that I have created that takes data from another system and syncs it into another database and then loads some data from there into CRM. This process is scheduled on an hourly basis so it runs quite often. It takes about 2 minutes for this process to run as well. About once a week this process will just hang and not continue through the code. It is always between where it truncates one table and tries to load the data into that same table. This always happens in the middle of the night of course. There is nothing that is written to the event logs on the application server when this happens. It just seems to lose the connection between the app server and the database server. There are no exceptions being thrown at this point either.

Has anyone else seen this issue? Is there anything else that I can check to see what is happening? I have tried to put some logging in between the two processes as well but that hasn't helped either.