Alert not executing daily

Hi

I have created a query as follows. It works no problem. When I add it to an alert and run it every minute, it runs without fail. If I then change it to run daily and set the time to 5 minutes from now ( I stay logged in), it doesn't run. Its the only alert I have created.

Query as follows:

select

'134' as FormType,

'T0020001' as PrintDef,

CardCode,

1 as AttGroup

FROM OCRD

where balance > 0

and Cardcode = 'CUS000984'

Why wouldn't the alert want to run at a set daily time?

I have tried to change the time format from 12h and 24h - none work.