If it works interactively then as far as this mailing list is concerned it
works. Executing in different environments such as a scheduler can affect any
program, not just R, and the reasons are due to the operating system, not R.
In general, you should be aware of the configuration and resource requirements
of R in general and your script in particular when switching execution
environments. You can learn more about what R depends on by reading the
R-admin.pdf file that comes with R. Environment variables such as R_LIBS are
common differences found between interactive and scheduled execution.
Another issue is permissions... scheduled execution often runs as a user who has
different permissions than your interactive login does... but that is very off
topic here.
One strategy you can try is creating a test script that just checks each
requirement that you identify and logs what it finds, and then you can change
either the way you are running the batch or add commands to the batch that
configure things the way your script needs them. When the logs indicate things
are set up right, you will know what to do to your actual processing script to
make it work.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at dcn.davis.ca.us> Basics: ##.#. ##.#. Live
Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
On February 9, 2015 9:07:24 PM EST, "Andr?s Felipe Fl?rez Rivera"
<afflorezr at unal.edu.co> wrote:>Hi everyone,
>
>I am trying to automate (on a Win7 system) an R script to read data
>from a
>DB2 data base and write it to file, for processing by another system.
>My
>code runs in the R gui perfectly. So I wrote a batch file to call this
>.r
>file and output results to script.out as shown below. When I double
>click
>the batch file everything runs successfully. When I schedule a task to
>run
>the batch file, the R code runs, collects data from DB2 data base, but
>the
>write to file fails every time, only save the header from sql query.
>
>R Code:
>
>library(RJDBC)
>library(rJava)
>jcc =
JDBC("com.ibm.db2.jcc.DB2Driver",".../db2jcc4.jar")
>conn =
dbConnect(jcc,"xxx",user="xxxx",password="xxxx")
>bd1 = dbSendUpdate(conn, "set current schema PRODUCCION")
>bd1 = dbSendQuery(conn,
>paste("SELECT *
>FROM VW_tabla_1"))
>dat4<- fetch(bd1, n = -1)
>write.csv2(dat4,file = ".../bd1.csv",row.names = F)
>dbDisconnect(conn)
>
>
>batch file code:
>
>\Program Files\R\R-3.0.1\bin\x64\R.exe" CMD BATCH --vanilla --slave
>"C:\Users\abg\SkyDrive\Documents\dat.R"
>
>
>thanks.
>
> [[alternative HTML version deleted]]
>
>______________________________________________
>R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
>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.