Update loop

[Gabriel2020]

Good morning everyone, how are you?

I have some flows in knime that I need to be updated hourly. Can you tell me what would be the best way? And how could it be done, please? If you have an example, I would also be grateful.

[fe145f9fb2a1f6b]

https://forum.knime.com/search?q=run%20schedule%20order%3Alatest

because you provide zero context (Hub?!, OS, …)

[hmfa]

Hi @Gabriel2020 .

Take a look at

Is it possible to create a workflow scheduler?

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

Is it possible to create a workflow scheduler?

Hi @Jacob_Yamauchi I add to what @rfeigel said a step-by-step guide to schedule your batch on Windows: Open Task Scheduler: Press Windows + R to open the Run dialog. Type taskschd.msc and press Enter. Create a New Task: In the Task Scheduler window, click on “Create Basic Task…” in the right pane. Name Your Task: Give your task a name and a description, then click “Next.” Choose the Trigger: Select when you want the task to start (Daily, Weekly, etc.) and click “Next.” If you s…

Best regards

[Gabriel2020]

Thank you for the answers above. However, I am very inexperienced with programming, and I was unable to develop this demand.

Giving more details, I have a flow in KNIME that connects to Google. I need it to be updated every day, it basically takes a database from a Google Sheets, organizes it, cross-references some information
and pastes it back into another sheet

[rfeigel]

Did you read this post and try to implement it? If so, what are specific problems you’re encountering?

Is it possible to create a workflow scheduler?

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_te…

[hmfa]

Hi @Gabriel2020

Also take a look at this for credential management

Credentials Config vs Connection Node Login

Hello @jdlueken84 , welcome to the Forum! How to provide the authentication credentials for the Microsoft SQL Server or any kind of database/file etc. in KNIME it really depends on the use case. (Do you want to share the workflow with others or not.) Generally speaking we can say using Credentials Configuration Node is more secure providing this kind of information in a workflow. In this way the credential data will not be saved in the workflow so in case of sharing this workflow others will …

Br