Home Forums SQL Server 2008 SQL Server 2008 - General Can alter or disable the SQL jobs RE: Can alter or disable the SQL jobs

  • February 21, 2017 at 9:37 pm

    #1929646

    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)

    This error encountered while inserting a record in a table where one of the columns is a VARCHAR or CHAR data type and the length of the value being inserted is longer than the length of the column. 
    To know in brief look at this: http://www.sql-server-helper.com/error-messages/msg-8152.aspx