This is on windows I am assuming? On linux, you can write a script, then
have cron execute it, similar to below, only I think you need to replace
Rterm with R CMD or something.
Put this in a batch file, and create a scheduled task. Make sure to put
the "start in" or "working directory" to the same as where your R script is.
This requires that you have %R_HOME% added to your path (on Windows at
least)
Rterm --verbose --no-restore --file=MorningStartup.r >
morningsummary-log.txt
Replace MorningStartup.r and morningsummary-log.txt with your R script
and a log file name of your choice.
HTH
cedrick
Jason Gasper wrote:
Greetings,
I am hoping someone can help me with a automation task. I would like
to auto-run a script at a scheduled time each night. Basically, this
auto-run would would call sqlQuery() and save the results of some math
to a table- basically archiving a live database table. Has anyone
done this before using R? Perhaps the way to approach this is through
the editor, but I don't see anything in Tinn that would provide this
capability. Further the editor would need to be opened (which I guess
could be done through windows task scheduler) and the R code would
then need to be ran.
It seems clunky, but some of the statistics cannot easily be done in
our database environment.
Thanks-Jason
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
