Hi,
I want set alarm for specific time region not for last 6 hour. For example, I want activate alarm for 4:00 am to 10:00 am and rest of time it shouldnt be acitvated. How can I set it ?
Thanks,
Hi,
I want set alarm for specific time region not for last 6 hour. For example, I want activate alarm for 4:00 am to 10:00 am and rest of time it shouldnt be acitvated. How can I set it ?
Thanks,
I did it by adding a subquery which determines if I should throw an alert.
For example, I have a query A with an alert set on it.
I add a query B with a column “MustSendAlert” and integrate this column in the alert query.
“MustSendAlert” is then defined as your alarm window. In MSSQL I defined one that only have the value “1” between 10am and 10pm.