Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

REP_WORKFLOWS

REP_WORKFLOWS

This view contains information about individual workflows and workflow scheduling.
The following table lists workflow and scheduling information in the REP_WORKFLOWS view:
Column Name
Datatype
Description
SUBJECT_AREA*
VARCHAR2 (240)
Folder name.
WORKFLOW_NAME*
VARCHAR2 (240)
Workflow name.
SCHEDULER_NAME*
VARCHAR2 (240)
Scheduler associated with the workflow.
START_TIME
TIMESTAMP
Start time configured for the scheduler.
END_TIME
TIMESTAMP
End time configured for the scheduler.
IS_RUN_ON_LIMIT
NUMBER
Object ID used for cyclic redundancy check (CRC).
RUN_OPTIONS
INTEGER
The workflow schedule type. Records the following values for each schedule type:
1 = Run on demand.
2 = Run once.
4 = Run every DELTA_VALUE seconds.
8 = Customized repeat.
16 = Run on Integration Service initialization.
18 = Run on Integration Service initialization and run once.
20 = Run on Integration Service initialization and every DELTA_VALUE seconds.
24 = Run on Integration Service initialization and customized repeat.
32 = Run continuously.
END_OPTIONS
INTEGER
The stop condition option for the workflow schedule type. Records the following values for each stop condition option:
0 = End on a date.
1 = End after the number of runs stored in RUN_COUNT.
2 = Run forever.
DELTA_VALUE
NUMBER
Number of seconds the Integration Service waits between successive workflow runs.
RUN_COUNT
INTEGER
Number of times the Integration Service runs the workflow before stopping the workflow.
SCHEDULER_ID*
NUMBER
Scheduler ID.
SCHEDULER_IS_REUSABLE
NUMBER
Specifies if scheduler is reusable.
SCHEDULER_COMMENTS
VARCHAR2 (2000)
Scheduler description.
SCHEDULER_VERSION_NUMBER*
NUMBER
Version number of the scheduler.
WORKFLOW_VERSION_NUMBER*
NUMBER
Workflow version number.
WORKFLOW_ID*
NUMBER
Workflow ID.
WORKFLOW_IS_VALID
NUMBER
Specifies whether the workflow is valid or not.
1 = valid; 0 = invalid.
WORFLOW_IS_SERVICE
NUMBER
Specifies whether the workflow is a service.
1 = service; 0 = not a service.
WORKFLOW_IS_RUNNABLE_SERVICE
NUMBER
Specifies whether the workflow is a runnable service.
1 = runnable service; 0 = not a runnable service.
WORKFLOW_LAST_SAVED
VARCHAR2 (30)
Date and time when the workflow was last saved.
WORKFLOW_COMMENTS
VARCHAR2 (2000)
Description of the workflow.
SUBJECT_ID*
NUMBER
Folder ID.
SERVER_NAME
VARCHAR2 (240)
Name of the Integration Service registered with the repository.
SERVER_ID
NUMBER
Integration Service ID.
WORKFLOW_IS_IMPACTED
NUMBER
Specifies whether the workflow is impacted by a change to dependent objects that may require the workflow to be revalidated.
0 = not impacted; 1 = impacted.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!