Alwayson查询主副本不同的JOB,Linkserver,Login

DECLARE @SQL AS VARCHAR(5000),
		@Primary AS VARCHAR(50),
		@Secondy AS VARCHAR(50);

SELECT @Primary='AAA',
	   @Secondy='BBB'


SET @SQL='SELECT NAME AS JOB_NAME FROM '+@Primary+'.[msdb].[dbo].[sysjobs] WHERE NAME NOT IN (SELECT NAME FROM '+@Secondy+'.[msdb].[dbo].[sysjobs])'


SET @SQL=@SQL+'SELECT SS.NAME AS LinkServer,LL.REMOTE_NAME FROM '+@Primary+'.master.SYS.SERVERS  SS
INNER JOIN '+@Primary+'.master.SYS.LINKED_LOGINS LL ON SS.SERVER_ID=LL.SERVER_ID
WHERE NAME NOT IN (SELECT NAME FROM '+@Secondy+'.[master].SYS.SERVERS)'


SET @SQL=@SQL+'SELECT NAME AS [LOGIN],DEFAULT_DATABASE_NAME FROM '+@Primary+'.master.sys.server_principals
WHERE  NAME NOT IN (SELECT NAME FROM '+@Secondy+'.[MASTER].sys.server_principals)'
EXEC(@SQL)