• The article is good but I think is overcomplicating the solution. Greg Larsen's Article besides using an undocummented feature is also missing a simple posibility:

    select *

    from openrowset('SQLOLEDB',

                    'Trusted_Connection=yes; Initial Catalog=Local',

                    'SET FMTONLY OFF; exec msdb.dbo.sp_help_job ')

    -- Where ...

    And you get your problem solved

    - without any undocumented feature

    - with a very simple query

    - without artificilly altering your jobs

    Hope this helps

     


    * Noel