It may be with security.  When running in query analyzer it's using your credentials; when running as a job, it's using the credentials from the service account.