Perfect, this information is very helpful, thank you. This type of scheduling is on our radar to address this year, and we'll keep your use case front and center as we build it.
In the meantime, the other alternative to a shiny app that we've seen as a workaround is to schedule the R Markdown document to re-render frequently, but include a condition in the code that checks for changes and results in a no-op if there aren't any. Certainly less than ideal though.