R help - Nov 2013 - Newbie Question: Repeatable Tasks

Hello mailing list,

 

I am new to R using RStudio in Windows and I just want to have repeated
tasks each day but could not find an answer to that reading a lot of intros,
scrolling through even more and reading on S.O. 

 

I connect to a database, load data, do calculation, write results to the
database and close connection. 


Can I save what I typed into the console as a script (I just figured how to
type into the Source window)? My idea is to have three scripts (if scripts
are the right way to do it): one for connection, second for calculation,
third to close connection. Would I then call them by "source(..R)" or
is
there a click-button-solution?

 

I would really appreciate if someone guides me in the right direction (link,
tutorial, example would be sufficient).

 

Thanks for your help

Chris


	[[alternative HTML version deleted]]

Just type the commands in the Source window of RStudioo, debug,  save as a .r
file and source it.

I don't see any particular reason to have three scripts once everything is
running correctly but you may find it useful.

John Kane
Kingston ON Canada

> -----Original Message-----
> From: csvirtual at gmx.de
> Sent: Mon, 4 Nov 2013 09:34:54 +0100
> To: r-help at r-project.org
> Subject: [R] Newbie Question: Repeatable Tasks
> 
> Hello mailing list,
> 
> 
> 
> I am new to R using RStudio in Windows and I just want to have repeated
> tasks each day but could not find an answer to that reading a lot of
> intros,
> scrolling through even more and reading on S.O.
> 
> 
> 
> I connect to a database, load data, do calculation, write results to the
> database and close connection.
> 
> 
> Can I save what I typed into the console as a script (I just figured how
> to
> type into the Source window)? My idea is to have three scripts (if
> scripts
> are the right way to do it): one for connection, second for calculation,
> third to close connection. Would I then call them by
"source(..R)" or is
> there a click-button-solution?
> 
> 
> 
> I would really appreciate if someone guides me in the right direction
> (link,
> tutorial, example would be sufficient).
> 
> 
> 
> Thanks for your help
> 
> Chris
> 
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at 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.
____________________________________________________________
FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your
desktop!