Greetings. I have an R Shiny dashboard that pulls data from an SQL server (using ODBC) every 30 minutes, both running on Azure instances in the same organization. Occasionally (sometimes multiple times a week, sometimes every few weeks), there is a network change that causes a communication link failure ("TCP Provider: Error code 0x274C") that persists if the browser is refreshed. The way that we currently fix it is to have one of the devs log into the server and enter "sudo systemctl restart shiny-server.service."
Is there a way to issue the service restart command from within the app, or force the whole app to restart (from within the app)?