Advanced ETL Processor can schedule transformations, packages, block transformations, import scripts, and SQL scripts through ETL Designer or the Execution Agent. Use Designer for attended runs and the Agent when the job must run as a Windows service without anyone logged in.
What You Will Learn
- Schedule a tested transformation for repeat execution.
- Choose between ETL Designer and Execution Agent execution.
- Enable execution before expecting scheduled actions to run.
- Avoid service-account path problems by using UNC paths.
Before You Start
Test the transformation manually before scheduling it. The scheduler is not a quality-control department. It is punctual, not psychic.
Scheduler Docs
The Understanding Scheduler documentation explains how scheduled packages, transformations, block transformations, import scripts, and SQL scripts are picked up for execution.
Start with how to enable Scheduler. By default, execution can be disabled, which is useful for safety and slightly less useful when you are wondering why nothing ran.
For attended work, review executing actions using ETL Designer. For production-style unattended execution, use Execution Agent and check timeout behaviour before relying on long-running jobs.
The How Scheduler Works section explains the queue model and next-run calculation. If the Agent runs under a Windows service account, use UNC paths instead of mapped drives for files and logs.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.