WF_RUN Parameters

You can execute the WF_RUN function using different parameter combinations:

  • WF_RUN with project name, workflow name and node name

  • WF_RUN with project ID, workflow ID and node IDs

  • WF_RUN with project name, workflow name, node name and time interval

  • WF_RUN with project ID, workflow ID, node ID and time interval

The RERUN_WORKFLOW RUN mode runs all nodes in a workflow regardless of how these nodes are connected. If a workflow contains two or more separate lineage of nodes, all lineages will be run, but the order of lineage execution is not deterministic. That is, the user cannot set the order for the lineage to run.

Table 8-4 lists the parameters that are used in the WF_RUN function.

Table 8-4 List of Parameters in the WF_RUN function

Parameters Description

P_PROJECT_NAME

Specify the project name that the workflow was created in.

P_PROJECT_ID

Specify the project ID that the workflow was created in.

P_WORKFLOW_NAME

Specify the workflow name to run.

P_WORKFLOW_ID

Specify the workflow ID to run.

P_NODE_NAMES

Specify the node names in the workflow to run.

P_NODE_IDS

Specify the node IDs in the workflow to run.

P_RUN_MODE

  • VALIDATE_ONLY: Validates parent nodes of the specified nodes.

  • RUN_NODE_ONLY: Runs the specified nodes. If the nodes have already run, they will not run again. If parent nodes have not run, then they will be run, otherwise they will be ignored.

  • RERUN_NODE_ONLY: Resets the status of the specified nodes to READY state. Then these nodes are run again.

  • RERUN_NODE_CHILDREN: Resets the status of the specified nodes and their children nodes to READY state. Then these nodes are run again.

  • RERUN_NODE_PARENTS: Resets the status of the specified nodes and their parent nodes to READY state. Then these nodes are run again.

  • RERUN_WORKFLOW: Resets the status of all nodes to READY state. Then the nodes are run (complete workflow run). Note: p_node_names is ignored.

P_MAX_NUM_THREADS

Specify the maximum number of parallel model builds across all workflows. Specify NULL for system determined. Use this parameter only if your system has plenty of resources, otherwise set this value to NULL to use the default value.

P_SCHEDULE

Specify existing schedule object defined in the Scheduler. If no value is specified for P_SCHEDULE, then the workflow is scheduled to run as soon as possible.

P_START_DATE

Specify the date and time on which this workflow is scheduled to start for the first time. If P_START_DATE and P_REPEAT_INTERVAL are set to NULL, then the workflow is scheduled to run as soon as possible.

P_REPEAT_INTERVAL

Specify how often the workflow repeats. You can specify the repeat interval by using the calendar or PL/SQL expressions. The expression specified is evaluated to determine the next time the workflow should run. If P_REPEAT_INTERVAL is not specified, then the workflow runs only once at the specified start date.

P_END_DATE

Specify the date and time after which the workflow expires and is no longer run. If no value for P_END_DATE is specified, then the job repeats indefinitely.

P_JOB_CLASS

Specify existing job class to run the workflow. If no value for P_JOB_CLASS is specified, then the default job class is used.

Parent topic: WF_RUN