Home Forums Article Discussions Article Discussions by Author Discuss content posted by Bret Lowery TSQL function to detect SQL Agent job state RE: TSQL function to detect SQL Agent job state

  • February 7, 2012 at 12:56 pm

    #1444071

    Grasshopper, both your posted SQL statements result in invalid length passed to substring errors when I attempted to execute the statements on SQL Server 2008R2 RTM.

    - -

    HTH -- Mark D Powell --