sprockit.Batch
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
Records in this table describe ETL batches (sometimes called cycles). A batch is an end-to-end run of all ETL processes, including any restarts required after process failures. A new batch is started when a brand new ETL run begins.
Records in the table that are older (in days) than Sprockit's LogRetentionPeriod property are automatically deleted.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK | BatchId | INT | Unique identifier for the batch. | IDENTITY |
| StartDateTime | DATETIME | The date and time at which the new ETL run began. | ||
| Sprockit Configuration | XML | XML document summarising property values configured at the start of the batch. | Since Sprockit v1.4. |
Relationships
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| (None). | |||
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| sprockit.Handler.RL1 | BatchId | BatchId |
Page generated from database metadata by DbScout.
1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.