Can alter or disable the SQL jobs

  • 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)

  • 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.

  • This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply