This tutorial shows how to use the Pause action in Advanced ETL Processor. Use it when a workflow needs a controlled delay before the next action runs, for example while a file settles, a remote system catches up, or an operator checks something during testing.
What You Will Learn
- Add a Pause action at the correct point in a package workflow.
- Set a fixed pause duration for controlled delays.
- Use calculated pause values when the wait time depends on context.
- Review the execution log to confirm when the pause ran.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Pause Action Docs
This tutorial uses the Pause action to stop package execution temporarily before continuing with the next linked action. It is useful for controlled delays, but avoid using it to hide a race condition. Waiting longer is not the same as fixing the workflow.
The Pause docs cover the parameters tab, variables tab, execution log tab, and calculated pause examples.
For related package design, review linking actions, default success actions, debugging actions, and working with variables.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.