sprockit.Execution

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

A row in this table records a single execution of a process.

Records in the table that are older (in days) than Sprockit's LogRetentionPeriod property are automatically deleted.

Column name1) Column type Description Notes
PK ExecutionId INT Unique identifier for the execution attempt. IDENTITY
RL1 ProcessId INT Identifies the process executed.
RL2 HandlerId INT Identifies the handler which executed the process.
Configuration NVARCHAR(255) Additional information about the process's runtime configuration. For SSIS packages, the value @ssisExecutionId indicates the SSIS catalog's internal execution ID for the package (refers to the SSISDB view [catalog].[executions]).
StartDateTime DATETIME The date and time at which the handler indicated by [HandlerId] reserved the process for execution.
EndDateTime DATETIME The date and time at which execution of the process stopped.
EndStatus VARCHAR(20) The status with which execution stopped. Usually Done, occasionally Errored.
ErrorNumber INT The SQL Server error number of the error which caused execution to stop. Only present when [EndStatus] = Errored. Failed SSIS package executions always have [ErrorNumber] = 50000. This is because Sprockit reads package failures from SSISDB execution logs and raises them internally as generic SQL errors.
ProcessType VARCHAR(4) Copied from sprockit.uvw_Process at [StartDateTime].
IsEnabled BIT Copied from sprockit.uvw_Process at [StartDateTime].
AvgDuration INT Copied from sprockit.uvw_Process at [StartDateTime].
BranchWeight INT Copied from sprockit.uvw_Process at [StartDateTime].
Priority TINYINT Copied from sprockit.uvw_Process at [StartDateTime].

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.

Attributes
(in this table)
Referenced table Referenced attributes
(in referenced table)
RL2 HandlerId sprockit.Handler HandlerId
RL1 ProcessId sprockit.Process ProcessId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)
sprockit.ExecutionActivity.RL1 ExecutionId ExecutionId
sprockit.IndexMaintenanceTask.RL1 ExecutionId ExecutionId
sprockit.Process.RL1 LatestExecutionId ExecutionId

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.