[ v1.5 ] [ Back to Sprockit home page ]

This view augments information available in sprockit.Execution.

Column name1) Column type Description Notes
PK, RL1 ExecutionId INT From sprockit.Execution
BatchStartDateTime DATETIME The start date and time of the batch to which the execution belongs. sprockit.uvw_Batch.[StartDateTime]
BatchRecency BIGINT The recency of the batch to which the execution belongs. From sprockit.uvw_Batch. The most recent batch has [BatchRecency] = 1, the batch before that has [BatchRecency] = 2 etc. Can be useful for constructing comparative performance analyses across recent batches.
ProcessId INT From sprockit.Execution
FqProcessName NVARCHAR(392) The fully-qualified process name corresponding to [ProcessId] From sprockit.Process
Execution StartDateTime DATETIME sprockit.Execution.[StartDateTime]
ExecutionEndDateTime DATETIME sprockit.Execution.[EndDateTime]
Duration INT The number of seconds between [ExecutionStartDateTime] and [ExecutionEndDateTime] NULL for processes in execution.
DurationHMS VARCHAR(8) [Duration] in HH:MM:SS format. NULL for processes in execution.
EndStatus VARCHAR(20) From sprockit.Execution
Execution Configuration XML(MAX) From sprockit.Execution

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)
RL1 ExecutionId sprockit.Execution ExecutionId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)

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.