Hello,
There is a bcp job that does every night processing and every other day it fails. I am not sure how to troubleshoot it. I did not design this job, so I am not sure how things in the job works. But when fails, i need to handle it. On the SQL Server job setting wise everything seems ok.. but to find the root cause of the problem, I am not sure how to handle it. Wondering if there was any bad data in the file, when the data is being dumped into the SQL SERVER. Not sure!. I checked the Windows event viewer SQL SERVER Log, job monitor, error logs.. nothing in specific details that i missing out?
Any ideas on how to trouble shoot the issue ?
Thanks in advance!
Answer by Fatherjack ·
Firstly I would look at the history of the job (right click job in SSMS and choose view history), this could give you an idea of what error messages are being returned on the times it fails.
After that, does the bcp step from the job run successfully, manually, every day? Have you started the job after it has failed over-night and had it complete successfully?
A bit more info from these two points will let us work towards a closer diagnosis
SQL Server Agent 2005 and SSIS
Agent Log Error: [LOG] Unable to read local eventlog (reason: 87)
different ways to schedule a job in SQL Server 2005
Create windows service to monitor/trace execution of sql sproc query
How to read or validate database mdf file when sql server is not running or offline