Alert not executing daily

[Former Member]

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.

[KennedyT21]

Please close your thread by marking helpful/correct answer.

Thanks,

Kennedy

[KennedyT21]

Hi Bradley,

i too face the same issue after change alert time , Restared the SBO Mailer Service. which solved my problem.

Regards

Kennedy

[Former Member]

Hi Kennedy

Thanks for your response. What I did was last night I set it to run this morning and it worked. Maybe it only registers daily alerts when the day begins? Anyway its working.

[Former Member]

I have tried hourly which works. The problem is, the idea is to have it run monthly on the 2nd of every month at 11pm. If daily doesn't work, I don't see monthly working.

[Former Member]

That would may not be possible in current B1 alert function. Probably a easy solution is setup a scheduled task out of B1 to remind user run it.

[Former Member]

Hi,

It is very hard to set alert daily (due to its process design). Try a longer interval instead to see if it works.

Thanks,

Gordon