Msg 11520, Level 16, State 1, Procedure sp_describe_first_result_set, Line 1
The metadata could not be determined because statement ‘EXECUTE master.dbo.xp_sqlagent_is_starting @retval OUTPUT’ in procedure ‘sp_is_sqlagent_starting’ invokes an extended stored procedure.
In SQL 2012 sp_help_job has changed. See this solution:
Workaround: SQL Server 2012 – OPENROWSET on sp_help_job throws “The metadata could not be determined”
Issue:In SQL 2012, stored procedures that call any other stored procedures or extended stored procedures that return result sets should specify WITH RESULT SETSSQL Agent’s stored procedure sp_help_job – returns single resultset if no parameters are passed to stored procedure. – returns 3 resultsets if job_id or job_name is specified. MSDN linkWhen RESULTSET is not described,…