-
1. Re: VizAlerts not always sending alert emails
Matt ColesSep 2, 2016 11:48 AM (in response to Sarah Slattery)
1 of 1 people found this helpfulWhat's your relative date filter set for? If you're using a static "minutes" value (say, 60), then depending on when your alert runs, you could miss alerts that run in the gaps. You can confirm that's what's happening by looking at the log files from VizAlerts and determining when it ran. If it was scheduled for 10am but ran at 10:05am, then it would potentially be missing extracts that failed between 9am and 9:05am (assuming the last execution ran on time).
If that's the problem, then to mitigate, I suggest you change to doing "previous hour", rather than specifying the number of minutes. That way, so long as your alert runs successfully, at any point over the following hour, it'll properly pick up any failures that occurred during the last hour (with no duplicate alerts either!).
If, however, the logs are showing that emails did go out to the proper people at the proper times, but the recipients say they didn't receive them, then it's time to go through rules, junk folder, "clutter", etc...and potentially follow up with whoever manages your SMTP server.
-
2. Re: VizAlerts not always sending alert emails
Sarah Slattery Sep 2, 2016 12:53 PM (in response to Matt Coles)Hey Matt,
Thanks for your super quick reply! We are currently using:
DATEDIFF('minute',[created_at_utc] ,NOW())<=61
This is probably the reason for the failure. I will update the logic to use previous hour.
Thanks!
Sarah
-
3. Re: VizAlerts not always sending alert emails
Matt ColesOct 21, 2016 8:58 AM (in response to Sarah Slattery)
1 of 1 people found this helpfulNo problem! As a reward for being a loyal VizAlerts user , here's a bonus calc that will accomplish the same "safe relative date" logic, but for alerts on a 15-minute schedule:
Date calc which determines the proper date range of the last 15-minute interval as defined by the quarter hour mark, rather than simply a set number of minutes earlier than “now”:
// Get the start date for the previous quarter hour (the end date will be the same thing but without the first and last lines)
DATEADD('minute', -15,
DATEADD('minute',
(INT(DATEPART('minute', NOW()) / 15)) * 15,
DATETRUNC('hour', now()) )
)
Edit: I don't know what I was on before. Replaced the "4"s with "15"s. I'll update again if I find any more issues...
-
4. Re: VizAlerts not always sending alert emails
Sarah Slattery Sep 2, 2016 1:09 PM (in response to Matt Coles)love it!