Introdução
Query - Consulta de usuário vinculado ao JOB
Passo a passo
SELECT TU.NAME [NOME USUÁRIO], TJ.JOBNAME [NOME JOB],
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[1]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[2]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[3]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[4]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[5]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[6]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[7]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[8]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[9]', 'nvarchar(max)') as CNPJ,
CAST(CNPJXML as XML).value('(CNPJCONFIG/CNPJLIST/CNPJ)[10]', 'nvarchar(max)') as CNPJ
FROM TBMONITORPERMISSION TM JOIN TBUSER TU ON TU.ID = TM.USERID JOIN TBNDDJOB TJ ON TJ.ID = TM.NDDJOBID WHERE TM.CNPJXML like '%08239926000146%'