I am using R in a Windows environment. 

I store my data in a Microsoft SQL database that gets updated automatically nightly.  Once my SQL db is updated, I wish to automatically run an R "script"

Any tips on "good" ways to approach this task? 

Is there an easy way to "launch" an R script using the Windows or other "scheduler"? Can I have an R-script run every hour, and within the script check to determine if my database is updated, and proceed only if it is updated?

       
	[[alternative HTML version deleted]]

