sprockit.Handler

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

Rows in this table record process handlers created by Sprockit's process manager. A process handler is a single invokation of the stored procedure sprockit.usp_ProcessHandler, running independently in the context of a single-step SQL Server Agent job.

Once started, a handler runs continuously as long as processes are available (Ready) for execution. When a handler finds no more work to be done, it quits, at which point its agent job is automatically deleted.

Handlers are created by Sprockit's process manager. The process manager runs throughout ETL processing, periodically monitoring handler capacity and demand, and starting new handlers when required (up to a specified maximum). A new handler is started by creating a new agent job to call sprockit.usp_ProcessHandler, then setting it running. Each new handler is recorded in this table.

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

Column name1) Column type Description Notes
PK HandlerId INT Unique identifier for the handler. IDENTITY
RL1 BatchId INT Identifies the ETL batch during which this handler was started.
SqlServerSessionId INT The handler's SQL Server @@SPID
SqlAgentJobName NVARCHAR(4000) The name of the SQL agent job running this handler. COMPUTED
StartDateTime DATETIME The date and time at which the process manager started this handler.
EndDateTime DATETIME The date and time at which this handler stopped executing.

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)
RL1 BatchId sprockit.Batch BatchId
Relationship Attributes
(in referencing table)
Referenced attributes
(in this table)
sprockit.Execution.RL2 HandlerId HandlerId
sprockit.Reservation.RL2 HandlerId HandlerId

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.