Error SQL71562 Procedure has an unresolved reference.

Applies to: SQL Server 2012, SQL Azure Database.
 

Problem Description.
 

A user reported the following schema errors while migrating to Azure SQL database from on premise SQL Server 2012:

Validation of the schema model for data package failed.
Warning SQL46010: Incorrect syntax near SELECT 1 FROM WF_LEVELMATRIX LM WHERE LM.
Warning SQL46010: Incorrect syntax near SELECT 1
Warning SQL46010: Incorrect syntax near SELECT 1
Warning SQL46010: Incorrect syntax near SELECT 1
Warning SQL46010: Incorrect syntax near SELECT 1
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to object [MSDB].[DBO].[SYSJOBS].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to object [MSDB].[DBO].[SYSJOBSTEPS].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to an object. Either the object does not exist of the reference is ambiguos because it could refer to any of the following objects: [MSDB].[DBO].[SYSJOBS].[JS], [MSDB].[DBO].[SYSJOBSTEPS].[JOB_ID] or [MSDB].[DBO].[SYSJOBSTEPS].[JS].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to object [MSDB].[DBO].[SYSJOBSCHEDULES].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to an object. Either the object does not exist or the reference is ambiguos because it could refer to any of the following objects: [MSDB].[DBO].[SYSJOBS].[JS], [MSDB].[DBO].[SYSJOBSCHEDULES].[JS], [MSDB].[DBO].[SYSJOBSTEPS].[JOB_ID] or [MSDB].[DBO].[SYSJOBSTEPS].[JS].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to an object. Either the object does not exist or the reference is ambiguos because it could refer to any of the following objects: [MSDB].[DBO].[SYSJOBS].[Jsc], [MSDB].[DBO].[SYSJOBSCHEDULES].[JOB_ID], [MSDB].[DBO].[SYSJOBSCHEDULES].[Jsc] or [MSDB].[DBO].[SYSJOBSTEPS].[Jsc].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to object [MSDB].[DBO].[SYSSCHEDULES].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to an object. Either the object does not exist or the reference is ambiguos because it could refer to any of the following objects: [MSDB].[DBO].[SYSJOBS].[Jsc], [MSDB].[DBO].[SYSJOBSCHEDULES].[Jsc], [MSDB].[DBO].[SYSJOBSCHEDULES].[SCHEDULE_ID], [MSDB].[DBO].[SYSJOBSTEPS].[Jsc] or [MSDB].[DBO].[SYSSCHEDULES].[Jsc].
Error SQL71562: Procedure: [dbo].[usp_Admin_SQLJob_GetAll] has an unresolved reference to an object. Either the object does not exist or the reference is ambiguos because it could refer to any of the following objects: [MSDB].[DBO].[SYSJOBS].[SC], [MSDB].[DBO].[SYSJOBSCHEDULES].[SC], [MSDB].[DBO].[SYSJOBSTEPS].[SC], [MSDB].[DBO].[SYSSCHEDULES].[SC] or
[MSDB].[DBO].[SYSSCHEDULES].[SCHEDULE_ID].






Cause


Objects or features related with MSDB database or SQL Server Agent jobs are not supported on SQL Azure databases.

For more information about features and objects not supported on SQL Azure databases, Please read "Azure SQL Database Transact-SQL differences" article on Azure web  site.

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.