/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== sprockit.Handler ======
~~PAGESWITCHER~~ [ [[..:..:sprockit|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 [[sprockit.Process|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, [[sprockit.Property#ProcessManagerPollInterval|periodically]] monitoring handler capacity and demand, and starting new handlers when required (up to a [[sprockit.Property#MaxConcurrentHandlers|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 ''[[sprockit.Property#LogRetentionPeriod|LogRetentionPeriod]]'' property are automatically deleted.


/* 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  |__**HandlerId**__  |INT  |Unique identifier for the handler.  |IDENTITY  |
|[[sprockit.Batch|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.  |  |

/* 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.4: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  |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  |


/* 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 */