anyone else have any ideas?

no, simply creating rows that get inserted into another table in the DB, pretty standard processing for SQL

I have, it runs as SA in SSMS. The Job runs as SA as well. The job would fail if there were invalid permissions. That isnt the...

I will check that out this weekend and report back....thanks for the article!

It actually has nothing to do with reporting services. this job just populates tables that are then used by reporting services in another job.

Yes, job executing as SA. Running the SP standalone as SA as well. Job doesnt work, standalone does.