SQL agent job Error while migrating from 2008 R2 to SQL 2014 for openrowset query
Try using WITH RESULTSETS as indicated by this connect item

https://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-error