sprockit.Event
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
You can also record custom execution properties in sprockit.Execution.
This table can be used to record ad hoc events. You can log events from processes in this table yourself using the utility SP sprockit.usp__LogExecutionEvent.
Sprockit uses this table to record warning messages when necessary. Warning messages can be identified as events having [IsWarning] = 1.
Records in the table that are older (in days) than Sprockit's LogRetentionPeriod property are automatically deleted. If you are logging ad hoc events in this table, you may wish to set the value of LogRetentionPeriod to -1.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| EventId | INT | Identifies this event log record. | ||
| EventDateTime | DATETIME | The date and time at which this event was logged. | ||
| IsWarning | BIT | Indicates if this event constitutes a warning of some kind. | 1 if the event constitutes a warning, otherwise 0. |
|
| RL1 | ExecutionId | INT | Identifies the sprockit.Execution from which this error was thrown. | Since Sprockit v1.5. |
| SourceDb | NVARCHAR(128) | The name of the database in which the reporting SP is found. | For SSIS packages, this is the name of the catalog folder. | |
| SourceSchema | NVARCHAR(128) | The name of the database schema in which the reporting SP is found. | For SSIS packages, this is the name of the SSIS project. | |
| SourceObject | NVARCHAR(128) | The schema-scoped name of the SP that reported the event. | For SSIS packages, this is the name of the SSIS package, including the .dtsx extension. |
|
| Message | NVARCHAR(MAX) | A message describing the event. | ||
| RowsAffected | BIGINT | The number of rows affected by the event. |
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 | ExecutionId | sprockit.Execution | ExecutionId |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.