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:
'134' as FormType,
'T0020001' as PrintDef,
1 as AttGroup
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.