Stack Overflow
Stack Overflow

Questions tagged [r-taskscheduler]

taskscheduleR is an R package for scheduling tasks in the Windows Task Scheduler using R scripts. Use this tag for questions about taskscheduleR. If your question is about Windows Task scheduler, use [windows-task-scheduler] instead.

taskscheduleR is an R package for scheduling tasks in the Windows Task Scheduler using R scripts. Use this tag for questions about taskscheduleR.

Links:

39 questions
0
votes
1 answer

Scheduling with taskscheduleR setting environment variables

Having some trouble scheduling tasks using taskscheduleR. Specifically I have had no issues scheduling the tasks however, when I try to set environment variables, the code will fail. I've tried explicitly calling Sys.getenv() at the begginning of my…
billash
  • 172
  • 1
  • 7
0
votes
1 answer

TaskscheduleR job returns fetch.write_memory error but works as a local job in RStudio on a virtual machine

I'm trying to set up an automated job that builds an csv file (by pulling aggregates from multiple MySQL databases) and sends an email out on a daily schedule. The entire script works as a local job (via RStudio jobs v1.2.1335) if the script is run…
Jacky
  • 710
  • 2
  • 8
  • 27
0
votes
2 answers

Using taskscheduleR on virtual machine

I want to schedule an R script to run daily on a virtual machine. The script connects to a DWH, downloads data and generates a .CSV file in the same folder. First, I installed R and Rstudio on virtual machine, ran my script manually and everything…
nba2020
  • 618
  • 1
  • 8
  • 22
0
votes
2 answers

Using Variables that are Not in the Enviornment of the Task Scheduler R

I am creating an Rscript that will run every 30min via the taskscheduleR package. However, there are variables that need to be updated every 30 min and some variables that should only be updated once a week. I would like the variables that are part…
Jordan Wrong
  • 1,205
  • 1
  • 12
  • 32
0
votes
0 answers

Schedule running R Script

I am trying to automate running a script (to be scheduled every 6 hours or so) which uploads a dataframe from R to presto. This requires connecting R to presto, which I have successfully established using the dBI package. I have saved the R and…
Shreyas Balakrishna
  • 23
  • 6
0
votes
1 answer

Scheduling an an R script that shows a popup/message box in case of an error on Windows

My aim is to check the http status of a website every 5 minutes and throw an alert message in case it is not 200. To keep it simple, I would like to discuss my question based on the piece of code given below. library(httr) a <-…
BRCN
  • 635
  • 1
  • 12
  • 26
0
votes
1 answer

writing R to xlsx2 naming sheetname today's date after doing taskscheduler

I'm trying to run an automated script using Rstudio add-in TaskscheduleR everyday. Then saving that to an appended excel spreadsheet with today's date. But I get the below error each time. I can get the writexlsx2 to work if I name the…
NR_DTW987
  • 43
  • 1
  • 4
0
votes
1 answer

Access Denied when scheduling a task with taskscheduleR package

I need to schedule the following R script: remove(list=ls()) library(DBI) library(ROracle) drv <- dbDriver("Oracle") connection <- dbConnect(drv, username="****", password="****", dbname="name_of_db") mydata <- dbGetQuery(connection, " …
user1010441
  • 59
  • 1
  • 7
0
votes
4 answers

R taskscheduleR not recognizing rscript

I am trying to use the R's taskscheduleR package to download data using a script every tenth of a minute (every 6 seconds). To do this, I have a script named getwmatadata.R which downloads data from an API and I am trying to call this script using…
Gaurav Bansal
  • 5,221
  • 14
  • 45
  • 91
1 2
3