SQL Query/JOB Error

Question

SQL Query/JOB Error

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

royce.bacon SSC Eights! Points: 990 More actions · Answer 1

One possibility is that the field you are converting to an int value is defined as a big int that can hold a value larger than the maximum value an int field can contain. If you have a value in the source field that is larger than the maximum int value you will get an overflow.

Leopard Ten Centuries Points: 1084 More actions · Answer 2

Hi Royce,

I already did that change, but another question is after doing all the changes there are jobs that failed to happen and the data is not successfully distributed and I have to do a manual input, is there a specific script to do this?

Rgds,

Leopard

royce.bacon SSC Eights! Points: 990 More actions · Answer 3

I won't have time to study the job script closely, but off hand it appears to me that you may just be able to hard-code the date(s) that were missed in the where clause and then run the script from SSMS.