Is it possible to create a workflow scheduler?

I have CSV and Excel files that constantly being updated externally. They are directly being processed through Knime manually and exported back as a CSV file. Is it possible to create a way to “read” and “write”, basically execute the entire workflow automatically at least once a day?

I tried looping with variables and I can’t figure it out.

Thanks in advance!

KAP workflows can be automated by writing a batch file and then executing the .bat file through Windows Task Scheduler. I’m not familiar with Apple or Linux batch files although I assume they have something similar to Windows and a similar scheduler. The KNIME server version has built in scheduling.

“C:\Program Files\KNIME\knime.exe” -nosave -consoleLog -noexit -nosplash -reset -application org.knime.product.KNIME_BATCH_APPLICATION -workflowDir=“C:\default_workflow_directory_here\forum_batch_test”

Give that a try, replacing your knime.exe location and your workflow directory location.

Take a look at this post:

2 Likes

Hi @Jacob_Yamauchi

I add to what @rfeigel said a step-by-step guide to schedule your batch on Windows:

  1. Open Task Scheduler:
  • Press Windows + R to open the Run dialog.
  • Type taskschd.msc and press Enter.
  1. Create a New Task:
  • In the Task Scheduler window, click on “Create Basic Task…” in the right pane.
  1. Name Your Task:
  • Give your task a name and a description, then click “Next.”
  1. Choose the Trigger:
  • Select when you want the task to start (Daily, Weekly, etc.) and click “Next.”
  • If you select Weekly, specify the day(s) of the week and the time.
  1. Action:
  • Choose “Start a program” and click “Next.”
  1. Select Your Batch File:
  • Click “Browse…” and locate your batch file (e.g., C:\path\to\your\file.bat).
  • Click “Next.”
  1. Finish:
  • Review your settings and click “Finish.”

Br

2 Likes

@Jacob_Yamauchi concerning batch you can take a look at this article:

1 Like