I noticed that you are selecting string: 'MAILS PENDING : ' and concatenating with count(*), this will result in having an alphanumeric value in variable: VAR1:

Code:

SELECT   'MAILS PENDING  :  ' || COUNT ( * )   "Correo Por Enviar" FROM
SCHEMA.CSIC_MAILS_fOR_SEND@VIRT.DB.TGU.COM  WHERE   estado = 0;

So if you try to do a numeric comparison: if [ $VAR1 -ge 200 ] it will fail because you have alphanumeric value in this variable.

I suggest you to modify your query to get just the record count:

Code:

SELECT COUNT(*) FROM
SCHEMA.CSIC_MAILS_fOR_SEND@VIRT.DB.TGU.COM  WHERE estado = 0;