SELECT * INTO #JobInfo

FROM OPENROWSET('sqloledb', 'server=(local);trusted_connection=yes'

, 'set fmtonly off exec msdb.dbo.sp_help_job @execution_status=4')

This works to get the info intoa temp table. The main advantage is no need to define the temp table. The select * into handles column creation.

I am not sure what the SET @sql = insert ... is doing. I was hoping it was simpler method to populate the tmp table, but I all i can see is populating the @sql variable.

cheers