question

Katie 1 avatar image
Katie 1 asked

SQL Server Agent job

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!

sql-server-2005administrationsql-agent
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
do you have the error message or step output?
0 Likes 0 ·

2 Answers

·
Fatherjack avatar image
Fatherjack answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image
Leo answered

As Jack said, you need to get the error message in History and you need to expand the job history and that will tell you where the step is failed. If you still couldn't figure it out, please post the Error Message.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.