Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kyle Neier Working with SQL Agent Durations RE: Working with SQL Agent Durations

  • August 23, 2012 at 11:49 am

    #1529392

    rmechaber (8/23/2012)

    That code errors out on my trial:

    Msg 536, Level 16, State 5, Line 1

    Invalid length parameter passed to the SUBSTRING function.

    Rich

    I've seen this before. There is a negative value in your duration ( like -954448987) While I don't know what causes this (maybe a SQL Agent bug) it is the reason for failing as the value is more than 6 characters. clear your agent history to get rid of the negative value or add a where clause "WHERE run_duration > 0"

    EDIT: Could also be a duration greater than 99 hours. In which case the where clause would be "WHERE run_duration BETWEEN 0 and 999999"

    -