Process Runner task

Use the Process Runner task to run a set of external commands with associated configurable parameters on a scheduled basis. This task can then be scheduled and executed like other tasks. You can specify to run the command after checking a condition.  The Process Runner task is generally added to a task chain. For more information, see Configuring-the-Task-chain.

For example, when you schedule a task to run an ETL daily, you can add a prerequisite to check if a file exists in a specific folder. The ETL task will run only when the prerequisite condition is fulfilled.

Example of ProcessRunner task

Execution configuration

Navigate to Administration > ETL & SYSTEM TASKS > System tasks. In the working area on the right, click the appropriate name (with the Type as ProcessRunner) available in the System tasks table. In the Run configurations table, click Edit  to edit the configuration details. In the Process runner execution configuration tab, in addition to general settings such as name, environment and description, you can edit the following properties:

• Process name list: A semicolon separated list of processes, for example process1;process2.

For each command list name, the following configuration parameters are available:

• Command: The command to execute.

  The Process Runner task executes any script that you have entered. Be careful about the command that you are entering, as it could result in loss of data or cause data to be out-of-sync.

• Notify on error: Select yes or no depending on whether you want a notification to be sent on the occurrence of an error in the external process executed by this task. If you select yes, then an email notification is sent to the configured users.
• Number of parameters for sleep: The number of parameters needed for the process; an arbitrary number of parameters can be configured.
• Parameter values for sleep: Values of all the required parameters.

All the results of the script appear as WARN in the Process Runner system task log. When the script exits with a non-zero code, the Process Runner task ends with the status FAILED.