This table holds the relationship between the Scheduler Job ID and Initiative schedule ID. This relationship identifies which Job relates to which initiative schedule in order to modify the entry in the INTVSCHED table when an initiative schedule is updated or deleted.
Column Description(s):
Column Name | Column Type | Description |
ESPOT_ID |
INTEGER NOT NULL |
The ID of the corresponding e-spot. Foreign key to the EMSPOT table. |
JOBID |
BIGINT NOT NULL |
The ID of the scheduler job. |
SCHED_ID |
INTEGER NOT NULL |
The ID of the initiative schedule. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031311060 |
ESPOT_ID+SCHED_ID |
Primary Key |
I0000909 |
JOBID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1158 |
ESPOT_ID |
EMSPOT |
EMSPOT_ID |
Cascade |
F_1095 |
SCHED_ID |
INTVSCHED |
INTVSCHED_ID |
Cascade |
F_1094 |
JOBID |
SCHCONFIG |
SCCJOBREFNUM |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.