SCHEDULE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

No

QUIETPERIOD

NUMBER

Yes

STARTTIME

DATE

No

INTERVALTYPE

NUMBER

No

INTERVALNUMBER

NUMBER

No

ACTIVE

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCHEDULE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Schedule.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Schedule.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

QUIETPERIOD

The Quiet Period value (between 0 and 3600 seconds) for the Schedule.

The Quiet Period avoids that a Build is performed while people are checking in files. When a Level Request is due to be started by the Scheduler, the system will check first if any source code activity took place during the defined number of seconds.

Only if there was no source code activity, it will be assumed safe to update from the source control system and execute the Level Request.

Key NULL Column Type (Size)

No

QUIETPERIOD

NUMBER

STARTTIME

The time at which the Schedule must start.

This value is used once each time the Scheduler is restarted and when the Schedule is set to Active.

Key NULL Column Type (Size)

Yes

STARTTIME

DATE

INTERVALTYPE

The Interval Unit.

Key NULL Column Type (Size)

No

INTERVALTYPE

NUMBER
Value List

0 = Minutes

1 = Hours

2 = Days

INTERVALNUMBER

The number of interval units by which the Schedule must verify outstanding tasks.

For instance, if the Interval Unit is set to MINUTES and the Interval Number to 10, the Schedule will check for changes in the Version Control Repository every 10 minutes.

Key NULL Column Type (Size)

No

INTERVALNUMBER

NUMBER

ACTIVE

Indication whether the Schedule is active or not.

Key NULL Column Type (Size)

No

ACTIVE

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

SCHEDULE_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

SCMLEVEL

Refer to the chapter SCMLEVEL for a detailed description of the table.

Foreign Key Referencing Column

SCMLEVEL_FK_1

SCHEDULEOID

Report Labels

SCHEDULE_ACTIVE_LABEL

English:

Active

French:

Actif

German:

Aktiv

SCHEDULE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCHEDULE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCHEDULE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SCHEDULE_INTERVALNUMBER_LABEL

English:

Interval Number

French:

Nombre d’intervalles

German:

Zahl der Intervalle

SCHEDULE_INTERVALTYPE_LABEL

English:

Interval Unit

French:

Unité d’intervalle

German:

Einheit des Intervalls

SCHEDULE_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SCHEDULE_OID_LABEL

English:

OID

French:

OID

German:

OID

SCHEDULE_QUIETPERIOD_LABEL

English:

Quiet Period (Sec.)

French:

Période d’inactivité (sec.)

German:

Inaktivitätsperiode (Sek.)

SCHEDULE_STARTTIME_LABEL

English:

Start Time

French:

Heure de début

German:

Anfangszeit

SCHEDULE_VERSION_LABEL

English:

Version

French:

Version

German:

Version