Execute terminal R

Dear all

I've built a tool where I scrape around 50 website with use of a R script. After that, R stores the data in a SQL dataset. Now, I have to run the tool twice a day manually. The steps are as follows:

  • connect to the SQL server by copy the login to the terminal and execute
  • insert the password also to the terminal and execute
  • then select the whole script and run it
  • lastly, end the session by pres the STOP button in the terminal

It would be nice if the script runs automatically twice a day, e.g. at 8 am and 8 pm or so. Is it possible to automate the above process?

Thanks in advance

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.