select count(*) AS TOTAL FROM CUPONS 
      where CSTAT NOT IN (100,101,102,110,135,150,151,301,302) and NFCE>0
      and EMISSAO>=HOJE-30 and TIMEDIFF(NOW(),DATA_HORA_VENDA)>'08:00:00'


 Este aqui dispara a msg de NFE pendente
   
 select count(*) AS TOTAL FROM CABECALHONF 
      where EMISSAO BETWEEN(HOJE-30) AND (ONTEM) AND
      CSTAT not in (100,101,128,205,102,110,301,302,303)