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