Hi ,

After the data named 2314K was removed from the table the Job was working fine.

I changed the code from

update Table_Test1 set Test_Code=1001 where Test_Code=1000

update Table_Test1 set Test_Code='1001' where Test_Code='1000'

The Job is working after I had changed the Code also.

Thank You very much for helping me.