T-Workflow Designer

59.3.10.40 Delay

Wait [hh:mm:ss] - a

Description:
Pauses the execution of the T-workflow until a certain waiting time has passed. The waiting time is calculated by adding the block's wait time (e.g. 60s) plus the database's job running frequency (5min by default).

For instance, if the wait block is set to 60 seconds, the actual waiting time will be 60 seconds after the database jobs start running.

NB: The job running frequency of a database, which by default is 5 minutes, can be set in the "SQL Management Studio > SQL Serve Agent > Jobs > Wf_Runtime.[MyDatabase]" by right-clicking on a schedule property and choosing "Properties > Schedules > Frequency".

Results:
a. Delay is over

NB: The “Wait” System Action requires the SQL Server Agent to be present; the SQL Server Agent is available in Microsoft SQL Server Standard Edition and Enterprise Edition.