/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.uvw_Execution ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|Back to Sprockit home page]] ]

This view augments information available in [[sprockit.Execution]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|PK, [[sprockit.Execution|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]]  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
Relationships with integrity enforced by a foreign key constraint have identifiers
prefixed with //FK//; others are prefixed //RL//.

[[sprockit:v1.5:Sprockit tables:Sprockit tables|Click here to view the data model diagram.]]
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|RL1  |ExecutionId  |[[sprockit.Execution]]  |ExecutionId  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|(None).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */