Post reply

Can alter or disable the SQL jobs

  • February 18, 2017 at 7:11 pm

    #320472

    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)

  • February 19, 2017 at 4:46 pm

    #1929291

    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.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

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

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