2 of 2 people found this helpful
You can call this effect "Alert drift". It occurs because "no more frequently than ____" really means "suppress alerts for a period of ___ after they are triggered". So depending on when they go off, Tableau Server will wait 24 hours past that time before trying again.
Solutions can be:
1. Run the alert hourly, and build a check for the current hour into your alert criteria using NOW(), and suppress any alerts for hours you don't care about.
2. Use a conditional subscription that can be scheduled at a specific time.
3. Are you mixing live and extracted connections in your workbook? If so, try extracting the live ones too, and refreshing all of them on a daily basis. Keeping the alert frequency at "as often as possible". It should run the alert when your extracts complete.
All are useful inputs for me. Your solution at 3rd point already working fine for 5 of my data alerts perfectly. Even I dont have live connection only this alert trouble me when I set 'As frequently as possble'.
I was in the process of sending subscription to multiple users from administrator login.
Unless I found a solution, will keep this thread open and will close with exact answer.
To clarify, if you have even a single live connection anywhere in your workbook--even if the viz you have your alert on does not use it--then your alert will run hourly by default. You must extract all connections in the whole workbook if you want the alert to run when your extracts refresh.
1 of 1 people found this helpful
Hi Matt and everyone,
The issue solved with temporary solution as it was critical, with sending subscription of view to users on the fixed time.
This option was only available to the dashboard owner who published the workbook not all have permission to add subscribers. So I have created a conditional subscription with workbook owner(one who published the workbook) to run at a same time daily.
So I can mark this as solved, but if i could find the better solution will update the same.
Matt Coles answer second point almost similar to my solution, so I marked that as correct answer.