Icon

kn_​example_​db_​wait_​execute

use the Wait node to execute a database query at fixed times

use the Wait node to execute a database query at fixed times

Please note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day!

use the Wait node to execute a database query at fixed timesPlease note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day! DB in memoryor as fileon a driveremove table if it exists to have a clean startsample_001st create (empty)hive tablesample_00sample filesample_00sample_00add_secondsexecutiontimeadd secondsSTARTHoursMinutesSecondsHourMinutesSeconds=> if the time is before theexecution time of current daythis will wait till next daycurrent_timecurrent_timesample_00with datacurrent_timeEND H2 Connector DB Table Remover DB Table Creator Data Generator DB Table Selector DB Writer Table Creator Wait... Create Date&TimeRange Date&Time Shift Chunk Loop Start Extract Date&TimeFields Table Rowto Variable String to Date&Time Table Rowto Variable ConstantValue Column DB Reader ConstantValue Column Loop End use the Wait node to execute a database query at fixed timesPlease note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day! DB in memoryor as fileon a driveremove table if it exists to have a clean startsample_001st create (empty)hive tablesample_00sample filesample_00sample_00add_secondsexecutiontimeadd secondsSTARTHoursMinutesSecondsHourMinutesSeconds=> if the time is before theexecution time of current daythis will wait till next daycurrent_timecurrent_timesample_00with datacurrent_timeENDH2 Connector DB Table Remover DB Table Creator Data Generator DB Table Selector DB Writer Table Creator Wait... Create Date&TimeRange Date&Time Shift Chunk Loop Start Extract Date&TimeFields Table Rowto Variable String to Date&Time Table Rowto Variable ConstantValue Column DB Reader ConstantValue Column Loop End

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2021-02-01
On NodePit since: 2021-02-01
Last update: 2024-04-26
Created with KNIME version: v4.3.1
Tags: waitnodetilltime

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!