Hi,

I just had the same issue and it was caused by a trigger that stores all updates in an audit table. The audit table stores some additional information as SUSER_SNAME and APP_NAME ...

After adding substring function the problem was solved

SUBSTRING(APP_NAME(), 1, 50)

APP_NAME() in ssms is about 47 characters but when you execute via a job it returns SQL AGENT .... + a guid ... which is longer than 50 chars.

Kind regards

Peter.