Yes. Only ADF is allowed at this point. Thanks.

No changes on the job that runs the stored procedure. Agent history shows sucessful runs every day. Adding output file now as you suggested. Thanks.

Not sure what you mean. Didn't restore this specific database to other server. We had to restore copy of its database to the same server with different name for some...

Thanks Sue.

Thanks. I'm assuming I can directly apply this below then, correct?

Microsoft SQL Server 2016 (RTM-CU5) (KB4013105) - 13.0.2197.0 (X64)   Feb 25 2017 12:07:22   Copyright (c) Microsoft Corporation  Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600:...

Thanks, any idea to speed it up? May be do it in a batch?

Bouncing the server put the database in recovery state and can’t be accessible.

So, I checked the sql server today and there wasn't anything running on the box. Again, SQL server became unresponsive for few minutes and this is the below message on...

Sorry, what is MARS?

This is what I've in extended event around that time from server B.

Network error code 0x2746 occurred while establishing a connection; the connection has been closed. This...

Thanks. Sorry, I should have made more clearer.

So, SQL server agent job on Server A fails during that time saying it couldn't log on to server B. It...

Mainly just business objects and there are some agent jobs that run hourly also fail at that time. But those jobs run fine other times.