Update code works in manual stored procedure but not when run as SQL Server Agent Job I have a stored procedure that deletes all records from an existing table, and then inserts new records. After the insert I have several update operations that change the value of one field.

If I run the SQL Server Agent job, the update does not happen. If I select and execute the update code manually, the update occurs.

If I execute the entire stored procedure manually, the update occurs.

No errors are thrown; everything 'works' but the update does not occur when I kick off the SQL Server job.
I resolved the issue - but do not understand it.

The system has a View corresponding to each Table.  One of the Views was used in my FOR XML PATH view.  

I substituted the no-permission Table for the View, and it works.  

The View has Public SELECT permissions.  The Table has no named permissions.

I think the SQL Server Agent Job should be able to SELECT from the View because of the public permission, but it cannot.