I use R daily to perform data analysis and create reports with Rmarkdown. I also use it a lot for the following pipeline: querying data, processing it and recording it in a spreadsheet in Google Sheets that feeds Dashboards in Google Data Studio. It turns out that all this I do on my machine, without any professional environment. I don't create virtual environments for better package management, for example. The update pipeline of several google sheets, for example, runs daily, automatically on my Windows machine (bat file).
A colleague wants us to start doing this now on the Linux server, in a virtual machine. Create an environment there and make it a little more professional. It turns out that I have no knowledge of Linux (I'll learn the basics in the next few days) and I don't know the best way to "orchestrate these Jobs" in R. For example, do I need Rstudio Server? Doing some research, I heard about chron. Would it be enough? Here, we have no team or structure. So I wanted to know where to look (materials for me to learn) and what would be the best way for me to make this a little more professional. I don't know how that works in an organized corporation that works with data. It doesn't have to be the most professional thing in the world, at least not right now.