Proc works - Job breaks

[CptTom]

I have a proc that runs just fine as a proc when run manually, but breaks part way through when run as a job. The proc drops the existing table recreates it from a trusted server. This runs a "Select * Into table FROM OpenQuery (Servename, 'Select * From owner.table').

The error message is always 0. This can happen on almost any of the tables it is importing.

It is not a permissions thing becuase it runs on several tables before crashing.