Chat now with support
Chat with Support

erwin Data Transformation 9.2.6 - User Guide

erwin Data Transformation v9.2.6_User Guide
erwin Data Transformation v9.2.6_User Guide
About this guide Document audience Document conventions Getting Started Adapters Configuration Configurations Administrator Tools Running DT on Event Running DT from Cloud Platform Log Viewer Utilities Users, Roles and Security Troubleshooting Information Examples of Workflow Configurations

Administrator Tools

Administrator Tools

Execute and Schedule Jobs

Execute and Schedule Jobs

The administrator tools include the scheduler, which is the engine that runs the jobs mainly related to the adapters set up by the user. The scheduler allows the user to schedule a single job; the user may define and schedule job sequences that run the desired jobs with the assigned priority.

According to the type of jobs available and the timing facilities, the user may schedule each single job (or a job sequence) with a certain frequency.

In this window the user can choose to manage the jobs available for all the configurations or to select a specific model configuration to work on the model administration jobs. In particular, selecting from the upper dropdown list:

All Configurations”, the user can schedule the Custom Job (see related section) and the Adapters (CM, WS, File and DB Adapters) which may be used by different models within their specific workflows. In this case, when an adapter is executed by the scheduler engine, an embedded workflow manager will trigger all the workflows using that adapter as its data source to execute

For each of the available Adapters, the user can set up the definition of single job to be scheduled (section “Job Scheduler”)

A specific model configuration name, the user manages the scheduling of the given model administration jobs, as

oModel backup

oMultisource jobs defined within that configuration workflow (thus needed only for those and not available for any other)

          For each of the available model configuration, the user can set up:

oIf it is active or not (checkbox “Active configuration”) – a configuration could exist even if it is not active

oThe definition of single job to be scheduled (section “Job Scheduler”)

oThe definition of each job sequencer (“Job Sequencer”)

Job Scheduler

Job Scheduler

For any kind of job, the user can set the scheduling time for each job after selecting it from the list.

Here are the timing parameters available:

Time Window - gives the opportunity to set a date interval for job execution. The jobs are executed according to the following repetition options and set-up time field.

Repetition by “Minutes” - set the repetition of a job every “xx” minutes (optionally within an hour interval).

Repetition “Hourly” - set the repetition of a job every “xx” hours (12 hours in the example).

Repetition “Daily” - set the repetition of a job every “xx” days (2 days in the example).

Repetition “Weekly” - set the repetition of a job each “day” of the week (Sunday and Monday in the example).

Repetition “Monthly” - the repetition of the job every “xx” (ordinal number) of the month (first day in the example).

Repetition “Once” - schedule the job to run just once, in the specified date and accordingly to the “Start Time” field.

When the user has completed the scheduling configuration, the user can store the scheduling parameters in the DT database by pressing the  button.

When the user presses the “Apply” button, either if they selected a job sequence or a single job, the field “Next Execution Time” (in the Job Sequencer or Job Scheduler respectively) is filled with the next expected time the job will run.

If it is required to unschedule a job, the user has to select it in the list and then press the  button.

If it is required to execute a job or a job sequencer immediately, the user has to select it in the list and then press the  button.

The  button closes the window.

Active Configurations

Active Configurations

If you want the scheduler to execute the jobs at the scheduled time, activate the configuration by checking the  check box. Once activated the check-box changes colour from yellow to green.

Please note that a configuration does not necessarily need to be activated to schedule its jobs.

The user is allowed to schedule any of the jobs, but the jobs will not be executed if at the execution time the configuration is not checked as “active”.

 

The “All the configurations” configuration is always active:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating