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 starts when a brand new ETL run begins (i.e. when the process manager agent job starts at step 1).
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 |
| sprockit.uvw_Batch.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.