Hi, our analytics team has dozens of workflows saved to Gallery and scheduled to refresh at regular intervals--or at least we did up until this weekend when the scheduled refreshed terminated for some unknown reason. We currently have a team investigating the cause.
The last run for the workflows took place between 10 PM on Friday 3/6 until 2 AM Saturday 3/7. We didn't notice the refreshes getting terminated until start of business Monday morning. Immediately our internal customers started asking us why things were out of date and we quickly found the issue and we're now going back and refreshing the data and re-initiating the scheduled refreshes. However, some of our workflows can't be retroactively restated, so we'll just have a gap in the data from this point on.
Needless to say, this is unfortunate for our org, so I'm trying to think of ways to avoid it in the future. Having a notification set to send an e-mail when a workflow errs is helpful only if the workflow gets kicked off to run to begin with. However, this will not help in cases when something has gone wrong to prevent the running of the workflow to begin with.
What I think we need is a system to auto-generate an e-mail to a person/group whenever a schedule is termed for any reason whether if it's by a person actively terming it, or for any other reason. Just as you get a confirmation e-mail whenever you term an e-mail subscription, getting a confirmation whenever a scheduled refresh is ended, would be extremely useful.
Thanks, Kurt
