Hi,
One of our Production Servers contains a job (Daily run) which gets the Data from another Server and dump into local DB. From last couple of days, it is failing with the reason "Unspecified error occurred on SQL Server. Connection may have been terminated by the server". So we ran the job, still failing with same reason, but when execute the script (which has been placed in the Job) manually Data getting loaded properly without any issue.
Today, we've monitored while job is running through sysprocesses, Eventviewer, interms of Lock and any process keeping this job wait etc. But we didn't find any clue. As expected, it got failed and when we've gone through Event Viewer (Application mode), it is showing "Process ID was killed by hostname XXX, host process ID X" (when it got failed). So again ran the script manually.
Please assist, as this is critical DB...