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_ALL_SCHEDULERS

REP_ALL_SCHEDULERS

This view displays a list of schedulers by folder.
The following table lists information in the REP_ALL_SCHEDULERS view:
Column Name
Datatype
Description
SUBJECT_ID*
NUMBER
Folder ID.
SCHEDULER_ID*
NUMBER
Scheduler ID (primary key).
SCHEDULER_NAME
VARCHAR2 (240)
Name of the scheduler.
START_TIME
VARCHAR2 (30)
Start time configured for the object associated with the scheduler.
END_TIME
VARCHAR2 (30)
End time configured for the object associated with the scheduler.
RUN_OPTIONS
NUMBER
The scheduler type. Records the following values for each schedule type:
1 = Run on demand.
2 = Run once schedule.
3 = Run on demand and Run once schedule.
5 = Run on demand and Delta schedule.
9 = Run on demand and Custom repeat.
18 = Run on server init and Run once schedule.
20 = Run on server init and Delta schedule.
24 = Run on server init and Custom repeat.
34 = Run continuously and Run once schedule.
36 = Run continuously and Delta schedule.
40 = Run continuously and Custom repeat.
END_OPTIONS
NUMBER
Specifies when the task must stop running.
DELTA_VALUE
NUMBER
Delta between successive runs (stored as seconds).
RUN_COUNT
NUMBER
Number of workflow runs. Used by END_OPTIONS column.
DESCRIPTION
VARCHAR2 (2000)
Description of the scheduler.
IS_REUSABLE
NUMBER
Specifies whether the scheduler is reusable or not.
LAST_SAVED
NUMBER
Date and time when this task was last saved.
VERSION_NUMBER*
NUMBER
Version number of the scheduler.
UTC_LAST_SAVED
NUMBER
UTC time (Coordinated Universal Time) when the scheduler was last saved.
UTC_CHECKIN
NUMBER
UTC checkin time.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!