• psred - Saturday, February 18, 2017 7:11 PM

    Hi,

    I am getting below error when I try to Alter or Disable the job.

    Alter failed for Job 
    ------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    ------------------------------
    String or binary data would be truncated. (Microsoft SQL Server, Error: 8152)

    What's the question?  Your error is pretty clear, so you'll want to look at your statement and see what you're trying to do where the string value is too long.