Understanding Scheduler

Scheduled actions can be executed by ETL Designer or by Execution Agent

Actions are Packages, Transformations, Import Scripts and SQL Scripts

Be default scheduler execution is disabled.

To enable scheduler:

  1. Click File → Options → Execute tab and UnCheck “Do not execute any actions”
  2. Click maintenance and check enable
 The second option allows disabling execution remotely using SQL or Management Console

Options Dialogue

Execute Actions in separate thread

Prevents user interface from freezing, this option decreases performance

Keep Designer open all the time, otherwise, nothing will be executed

Another way to execute the actions is to use the agent. The agent is windows service which is constantly running in the background. It executes actions automatically without user interaction.

To enable agent execution:

  1. Make sure that agent service is registered
  2. Start the agent service
  3. Select Maintenance Tab
  4. Enable Agent execution

 This option allows disabling execution remotely using SQL or Management Console

Terminate on timeout

Timeout is approximate. Once the timeout is reached current action will terminate or stop executing and no further actions would be executed. This option only works with the agent.

Options Dialogue

Execute One Action at the time

Disables parallel execution so only one action is executed at the time. This option only works with the agent.

Avoiding problems

To avoid access issues with access right we always recommend using the actual user to run it.

Mapped drives do not exist in windows services world. Always use UNC path.

Use UNC path for logging.

When execution is enabled, there are two processes constantly running. One is checking schedule and if there is something to execute it adds the record to the queue. Another one is checking the queue and if it is not empty it executes the action.

Once the record is added to the queue scheduler calculates next time of execution.

Remember: Everything is related to the current time, right now is 16:00. If we schedule for execution at 15:00 it will be tomorrow’s date or if we schedule execution at 17:00 execution date will be today.

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

Confused? Ask question on our ETl forum

  • knowledgebase/understanding_scheduler.txt
  • Last modified: 01/08/2022 14:15
  • by admin