Pause Dynamic Action

About

The “Pause action” is used to temporarily halt the execution of a workflow at a specific point. This allows the workflow to wait for certain conditions to be met, such as manual intervention, external input, or a predefined amount of time, before continuing with the next steps. It is useful when a delay or user interaction is required in the workflow process.

Metadata tab

Pause Action - Metadata tab
 

  1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
  2. This option is typically used for debugging and is not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Parameters tab

Pause Action - Parameters tab

Variables tab

The Variables tab defines which variables are updated during the execution of the action.

Pause Action - Variables tab

Execution log tab

The Execution Log tab is populated after the action has been executed. Double-click a row to view the detailed execution log.

Pause Action - Execution log tab

Calculated Pause example

Pascal

Pause Action - Calculated Pause Value example - Pascal
  Script

begin
 if DayOfWeek(Now)=3 then
    begin
     Result:='00:00:01';
    end
 else
    begin
     Result:='00:00:20';
    end;
end;

Python

Pause Action - Calculated Pause Value example - Python
  Script

import datetime;
if datetime.datetime.today().weekday()==0:
   Result.Value='00:00:01'
else:
   Result.Value='00:00:23'

Video Tutorial


For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on November 29, 2023 • 2 min read • 276 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License