/* 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 [[..:introduction#process manager|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(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.   |

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