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 making an entry in this table, creating a new agent job to call sprockit.usp_ProcessHandler (with the new [HandlerId] value as a parameter), then setting it running.
Records in the table that are older (in days) than Sprockit's LogRetentionPeriod property are automatically deleted.
Columns
| 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(128) | 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. | ||
| Status | VARCHAR(20) | The execution status of this handler. | Since Sprockit v1.5. A handler has status 'Starting' at creation, which changes to 'Running' when its SQL Agent job begins execution. |
Relationships
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| RL1 | BatchId | sprockit.Batch | BatchId |
References to this table from others
| 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.