Stored procedure working when run manually, not running in SQL Agent Job
I had this same issue when google geocoding and parsing the XML result.  Seems that when run via an SQL job the XML result was being truncated.

Found the solution here: http://www.progtown.com/topic376715-a-problem-with-spoagetproperty-p2.html

Had to put:

SET TEXTSIZE 2147483647;


at the start of my stored proc.