Alerts Management

[Former Member]

Hi Experts

I've experienced issues with new Alerts that I've created which refuse to run even though (1) the Alert is Active and (2) the underlying Query on which the Alert is based works. It seems to be a hit and miss affair as to whether the Alert will work on creation!

Has anyone experienced such issues and have you come up with solution to the problem.

Derek

[Former Member · Accepted solution]

Hi Derek,

Could you post your query here and let others to check?

Thanks,

Gordon

[Former Member · Accepted solution]

here you go Gordon

SELECT T0.[CardCode], T0.[CardName], T1.[SlpName], T0.[frozenComm] FROM OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode WHERE T0.[frozenFor] ='Y' AND T0.[frozenFrom] =CONVERT(VARCHAR(10),GETDATE(),111) AND T1.[SlpName] = 'Alistair Simpson'

Derek

[Former Member · Accepted solution]

Try this:

SELECT T0.CardCode, T0.CardName, T1.SlpName, T0.frozenComm

FROM dbo.OCRD T0

INNER JOIN dbo.OSLP T1 ON T0.SlpCode = T1.SlpCode

WHERE T0.frozenFor ='Y' AND DateDiff(DD,T0.frozenFrom,GETDATE()) = 0

AND T1.SlpName LIKE '%Alistair Simpson%'

What frequency has been set?

[Former Member · Accepted solution]

I'll give it a try Gordon and let you know how I get on.

Frequency was 1600 hours daily.

Derek

[Former Member · Accepted solution]

That would be a tough alert to create. I have never got it work exactly if set alert once daily at any time. Try every few hours in frequency to see if it works or not.

[Former Member · Accepted solution]

Hi Gordon

I changed Frequency to every 3 hours and it appears to have worked. Just for my own interest, why would the alert be so difficult based on daily frequency?

Derek

[Former Member · Accepted solution]

It is a mystery to me too.