Scheduling and manually executing a transformation or job
To schedule a transformation or job
- Create an execution instance on the AR System server using the UDM:Execution form.
- Select the Directory where the transformation or the job is created.
- Select the Type of instance that you want to execute - Transformation or Job.
- Select the Job name or the Transformation name.
- Enter a unique Execution Instance Name when you are creating the execution for the first time.
- Select the Log Level
- In the Operation field, select Create Execution Instance.
- Click Save.
- Create an entry in the AR System Job form and include the date, time, and recurrence.
- In the Job Type field, enter Pentaho.
- Enter a unique Job Name for the schedule.
- Select Status and set to Active.
In the Schedule Information section, select the Type of schedule and Recurrence as per the following table:
Type
Recurrence
Run Once
weekofmonth=;dayofmonth=;weekdays=;frequency=1;subtype=;
By Minute
weekofmonth=;dayofmonth=;weekdays=0-1-2-3-4-5-6;frequency=30;subtype=;hours=0-1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23;
Hourly
weekofmonth=;dayofmonth=;weekdays=0-1-2-3-4-5-6;frequency=60;subtype=;hours=0-1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20-21-22-23;
Daily
weekofmonth=;dayofmonth=;weekdays=;frequency=1;subtype=;
Weekly
weekofmonth=;dayofmonth=;weekdays=0;frequency=1;subtype=;
Monthly
weekofmonth=;dayofmonth=;weekdays=;frequency=;subtype=;
- Depending on the Type, select a value for Next Collection Time.
- In Parameters, enter operation = 1.
- In Job Access, provide permissions to control access to the Schedule Job.
- Click Save.
- Create an entry in the AR System Job Item form with the Atrium Integrator transformation or job name and execution instance name that you created in step 1.
- In Job ID, enter the schedule Job ID that you created in step 2 in the AR System Job form.
- Enter the schedule job name in Job Item Name.
- Enter the parameters in Params as follows:
type=1;execution_instance_name=<AIjobname_schedule> - Click Save.
To manually execute a transformation or job
- Create an Execution Instance on the AR System server using the UDM:Execution form.
- Select Create Execution Instance in the Operation field.
- Enter information in the other fields on the form.
- Use the UDM:Execution form to create another entry.
- Select Start Execution Instance in the Operation field.
You can also stop, pause, resume, or remove an execution instance by selecting the appropriate value from the list in the Operation field.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*