Icon

m_​025_​trigger_​execution

use the Wait node to execute a database query at fixed times (execution workflow)

use the Wait node to execute a database query at fixed times (execution workflow)
025 - loop thru a number of times with inbetween

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 times (execution workflow)025 - loop thru a <Iteration> number of times with <add_seconds> inbetweenPlease note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day! knime://knime.workflow/../data/database.h2wait until the next roundexecutiontimeadd secondsSTARTHoursMinutesSecondsHourMinutesSeconds=> if the time is before theexecution time of current daythis will wait till next daycurrent_timecurrent_timetrigger_file.csvcheck the (potentially)newtrigger filetrigger_file.csvtrigger_meta_listcheck theexistingtrigger filestrigger_meta_listtrigger_meta_listMaxLast modificationcomparethe twotimestampsnew - Last modified dateexisting - Last modified dateport_to_select$new - Last modified date$ > $existing - Last modified date$ => 0TRUE => 2=> this is where the decision is madeport_to_selecttrigger_meta_listwrite backthe latest timestampof the trigger filefoundexclude path variables0 - file is newer - top port - execute component2 - file is not newer - bottom port - do nothingthis happenswhen the trigger fileis newer=> you couldchange this component to whatever you wantknime://knime.workflow/../data/list_times.table=> this is your plan of executionevery <add_seconds> secnds for <Iteration> roundssee what has happened insample_00see what has happened intrigger_meta_listsee what has happened insample_00trigger_meta_listn_port_selectednew_last_modified_datenew_last_modified_date H2 Connector 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 List Files/Folders Files/FoldersMeta Info DB Table Selector DB GroupBy DB Reader GroupBy Column Appender Column Rename Column Rename Rule Engine Table Rowto Variable DB Writer Column Filter CASE SwitchVariable (Start) CASE SwitchVariable (End) Variable Loop End Component Table Reader DB Table Selector DB Table Selector DB Reader DB Reader ConstantValue Column ConstantValue Column String to Date&Time Joiner Sorter use the Wait node to execute a database query at fixed times (execution workflow)025 - loop thru a <Iteration> number of times with <add_seconds> inbetweenPlease note: If the time of day has passed when the workflow reaches the Wait node it will wait until the same time next day! knime://knime.workflow/../data/database.h2wait until the next roundexecutiontimeadd secondsSTARTHoursMinutesSecondsHourMinutesSeconds=> if the time is before theexecution time of current daythis will wait till next daycurrent_timecurrent_timetrigger_file.csvcheck the (potentially)newtrigger filetrigger_file.csvtrigger_meta_listcheck theexistingtrigger filestrigger_meta_listtrigger_meta_listMaxLast modificationcomparethe twotimestampsnew - Last modified dateexisting - Last modified dateport_to_select$new - Last modified date$ > $existing - Last modified date$ => 0TRUE => 2=> this is where the decision is madeport_to_selecttrigger_meta_listwrite backthe latest timestampof the trigger filefoundexclude path variables0 - file is newer - top port - execute component2 - file is not newer - bottom port - do nothingthis happenswhen the trigger fileis newer=> you couldchange this component to whatever you wantknime://knime.workflow/../data/list_times.table=> this is your plan of executionevery <add_seconds> secnds for <Iteration> roundssee what has happened insample_00see what has happened intrigger_meta_listsee what has happened insample_00trigger_meta_listn_port_selectednew_last_modified_datenew_last_modified_dateH2 Connector 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 List Files/Folders Files/FoldersMeta Info DB Table Selector DB GroupBy DB Reader GroupBy Column Appender Column Rename Column Rename Rule Engine Table Rowto Variable DB Writer Column Filter CASE SwitchVariable (Start) CASE SwitchVariable (End) Variable Loop End Component Table Reader DB Table Selector DB Table Selector DB Reader DB Reader ConstantValue Column ConstantValue Column String to Date&Time Joiner Sorter

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-19
On NodePit since: 2021-02-21
Last update: 2024-04-27
Created with KNIME version: v4.3.1

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

Try NodePit Runner!