Modeling Business Processes and Their Execution > Getting Started with the Business Process Management Extension in the Desktop Application > Building Process > Creating Stage Steps > Creating the ETL Task Step
In this article:
Setting Up Step Description Parameters
To create an ETL task execution step, open the ETL task step wizard.
Setup of the ETL Task step includes the following operations:
Set up basic step properties. After basic step properties have been determined, click the Next button.
Set up link between parameters of data entry form/report and process.
To set up step description parameters, use the Step Description page in the step wizard:
Set the parameters:
Owner Role. The box is mandatory. In the drop-down list select the user or the group of users responsible for step execution on process execution.
If the list does not contain the required group of users, click the Open Security Manager button. The dialog box of the security manager of Foresight Analytics Platform, which enables the user to create the required group of users.
ETL Task. The box is mandatory. Select an ETL task in the drop-down list, you can use search. The list contains repository objects tree where ETL tasks and folders containing them are only displayed. To edit the selected ETL task, click the 
button. The ETL task editor dialog box opens.
Step Execution Time. Specify the time, in which a step should be executed on process execution. Execution time is counted from step activation.
Enter a numeric value of step execution time and select a time measurement unit in the list: minute, hour, day (default), week, month, quarter, half-year, or year.
To determine time, by which step must be finished, select the Finish Step By checkbox. When the Minute or Hour measurement units are selected, this box is hidden.
If the step is not finished by the scheduled execution period, the step status becomes Expired.
The step execution period impacts the whole process execution period, which is determined during process start.
Step Description. The box is optional. A text box for entering a comment for a step.
After the parameters have been determined on the Step Description page, click the Next button.
To execute ETL task with the same parameters as the running process step, set up a link between ETL task parameters and process parameters on the Manage Parameters of the step wizard:
Set the parameters:
Fixed. Select the Fixed dialog box to limit a list with parameters values used on starting ETL task.
ETL Task Parameter. The list contains ETL task parameters. It is filled in automatically.
Process Parameter. In the Process Parameter drop-down list select a process parameter that corresponds to the data entry form parameter.
If there is no required process parameter, click the Process Parameters button. The Process Settings and Parameters dialog box opens, in which one can add a process parameter.
After the parameters have been determined on the Manage Parameters page, click the Next button.
To set up the events executed automatically on step execution start and end, use the Events page in the step wizard:
Create a list of executed operations:
Select the tab with the configured event on the Events wizard page. The following events are available:
Before Execution. The list of actions will be started before executing the current step in the specified order.
After Execution. The list of actions will be started after executing the current step in the specified order.
On Rejection. The list of actions will be started on the current step rejection. The list is available for steps with manual execution. If the step is executed automatically, the tab is not displayed.
On Deadline Disruption. The list of actions will be started on deadline disruption to execute the current step in the specified order. To execute the actions:
When the server execution of processes is selected, select the Check Deadline Disruption of Steps checkbox on the Scheduler page and set check frequency.
When the client execution of processes is selected, select the Check Deadline Disruption item on the Administration page.
Click the 
Add button on the toolbar and select the added action:
Execute Fore Method. Determine:
Unit. In the drop-down list select a unit written in the Fore language, the list contains all repository units and folders containing units. Search by unit name is available.
To edit the selected unit, click the Edit button.
To create a unit, click the Add button.
Method. Select method in the drop-down list. The list contains all unit methods corresponding to the signature:
Sub <Fore-method name>(Sender: IBProcessInstance; Args: IBProcessStepStateEventArgs);
Parameter:
Sender. Process instance.
Args. Event information: step, step old state, new state.
To refresh the methods list, click the 
Refresh List button.
To copy method signature, click the 
Copy Signature button.
Send Email. Set message parameters:
To. Enter address of one or several main recipients separated by the ; character. The box is mandatory.
Copy. Enter address of one or several recipients separated by the ; character.
BCC. Enter address of one or several recipients separated by the ; character. The address will be hidden from other message recipients.
Subject. Enter message subject.
Contents. Enter message contents using the option of variables values substitution with step parameters, links to step objects to view in the web application, file attachments.
NOTE. The number of added actions is unlimited.
To reorder operation execution, use the 
Move Up and 
Move Down buttons on the toolbar on the Events wizard; to delete, click the 
Delete button.
The list of automatically executed actions can be empty.
To determine parameters on the Events page, click the Finish button.
After creating the process steps, set up steps execution conditions
See also:
Open the wizard
Add Step button on the Process ribbon tab and select the type of created step in the menu that opens.