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.