PowerCenter - Workflow task

2 - Task Type

Task Type Description
58 Command
59 Decision
60 Event Wait
61 Event Raise
62 Start
65 Email
66 Timer
67 Assignment (Variable ?)
68 Session
70 Worklet
71 Workflow
91 Control

To have the type of command (task type 58), check the task_name of the table OPB_TASK

SELECT DISTINCT
  TASK_TYPE,
  COMP_TYPE.OBJECT_TYPE_NAME
FROM
  OPB_TASK TASK,
  OPB_OBJECT_TYPE COMP_TYPE
WHERE
  TASK.TASK_TYPE = COMP_TYPE.OBJECT_TYPE_ID
ORDER BY
  TASK_TYPE ASC;

3 - Documentation / Reference

  • PC_861_WorkflowBasicsGuide.pdf - CHAPTER 5 - Tasks
dit/powercenter/task.txt ยท Last modified: 2017/09/06 19:56 by gerardnico