----------------------------] DEBUG ----------------------------] <> ] Procesar fecha: [2026-01-16] ] Query a procesar: [ SELECT TOP 1 tur_numero ,c.cli_tel as telefono ,c.cli_nombre as nombre, c.cli_dni as doc ,m.med_nombre AS Med ,tt.tit_abrev AS Tit ,DATEPART(dw,tur_fecha) as diaSemana ,DATEPART(dd,tur_fecha) as diaFecha ,DATEPART(mm,tur_fecha) as mesFecha ,t.tur_hora AS Hora ,ISNULL(t.tur_confirmado,0) as confirmado FROM dbo.turnos as t INNER JOIN dbo.clientes as c ON c.cli_codigo = t.cli_codigo INNER JOIN dbo.medicos as m ON m.med_codigo = t.med_codigo INNER JOIN dbo.tbl_titulos tt ON tt.tit_codigo = m.tit_codigo WHERE t.cli_codigo > 1 AND t.turRecoWht = 0 AND ISNULL(t.tur_confirmado,0) = 0 AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-16' AND t.med_codigo NOT IN (64,88,113,121,89,74)] ] turnos encontrados a procesar: [1] >> TURNOS A PROCESAR[1] SELECT TOP 1 tur_numero ,c.cli_tel as telefono ,c.cli_nombre as nombre, c.cli_dni as doc ,m.med_nombre AS Med ,tt.tit_abrev AS Tit ,DATEPART(dw,tur_fecha) as diaSemana ,DATEPART(dd,tur_fecha) as diaFecha ,DATEPART(mm,tur_fecha) as mesFecha ,t.tur_hora AS Hora ,ISNULL(t.tur_confirmado,0) as confirmado FROM dbo.turnos as t INNER JOIN dbo.clientes as c ON c.cli_codigo = t.cli_codigo INNER JOIN dbo.medicos as m ON m.med_codigo = t.med_codigo INNER JOIN dbo.tbl_titulos tt ON tt.tit_codigo = m.tit_codigo WHERE t.cli_codigo > 1 AND t.turRecoWht = 0 AND ISNULL(t.tur_confirmado,0) = 0 AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-16' AND t.med_codigo NOT IN (64,88,113,121,89,74) >>POD TOTAL[1] ] Actualizar destinatario a procesar: [ UPDATE dbo.turnos SET turRecoWht = 1,tur_RecoWhtFechaEnvio=GETDATE(),turRecoWhtRechazado=0 WHERE tur_numero = 923932] ] Destinatarios ] Array ( [0] => Array ( [men_id] => 1135585206 [msg] => Kk1BUlRJTkVaIEFMSUNJQSBJU0FCRUwqIG5vcyBjb250YWN0YW1vcyBkZXNkZSAqQ09SRE9CQSBNRURJQ0FMIENFTlRFUioKcGFyYSByZWNvcmRhcmxlIHF1ZSBlbCBkw61hICp2aWVybmVzIDE2IGRlIGVuZXJvKiBhIGxhcyAxNDowMCB0aWVuZSB1biB0dXJubyBjb24gKkRSIEFSQ09TIC0gQUdVSVJSRSBKVUFOIENBUkxPUyoKUmVzcG9uZGEgKjEqIHBhcmEgY29uZmlybWFyIGVsIHR1cm5vIG8gKjIqIHNpIGRlc2VhIGNhbmNlbGFybG8uCgpFc3RlIGVzIHVuIG1lbnNhamUgYXV0b23DoXRpY28sIGdyYWNpYXMKU2kgZGVzZWEgbW9kaWZpY2FyIGVsIHR1cm5vLCBwb2Ryw6EgcmVhbGl6YXJsbyBwb3IgbG9zIHNpZ3VpZW50ZSBjYW5hbGVzLlRlbMOpZm9ubyBmaWpvOiAwMzUxIDQ4MjU5NDAKV2hhdHNhcHA6IDM1MTYzMzU5MzgKVHVybmVybyBXZWI6IGh0dHA6Ly9jYmFtZWRpY2FsY2VudGVyLmNvbS5hci9tb2JpbGUK [destiny] => 5493512349009 [customer] => a340e4bd594ea87bf22c565d838ffc39 [cli] => a340e4bd594ea87bf22c565d838ffc39 [k] => R2VudGl1bTIyJA== [token] => 00000000000000000000 [action] => send [flagFlowCreated] => ) ) >>TOTAL MENSAJES[1] >>POSD ACTIVOS 1 **************]