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