[ 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.

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 with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.

Click here to view the data model diagram.

(in this table)
Referenced table Referenced attributes
(in referenced table)
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.

Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.