Re: [R] Auto execute R script

2009-11-12 Thread Jason Gasper
Thanks Cedrick for your help- the batch file approach makes complete sense. It is a windows operating system. Cedrick W. Johnson wrote: 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

Re: [R] Auto execute R script

2009-11-12 Thread Cedrick W. Johnson
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

[R] Auto execute R script

2009-11-12 Thread Jason Gasper
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 t