Gong! The OPENROWSET solution isn't working. Thought I saw it work but more tests show a SQLOLEDB error about object has no columns. Puzzling.

btw, I clipped the last ) -...

Yes, that would work. I found another idea using OPENROWSET:

insert into #jobtbl (<<many columns>>) from

(select a.* from OPENROWSET('SQLOLEDB','USER';'PW','exec msdb..sp_help_job') as a

This appears to work but I'm not pleased with...