[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
This view augments information available in sprockit.Process.
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| RL1 | ProcessId | INT | From sprockit.Process | |
| DbName | NVARCHAR(128) | From sprockit.Process | ||
| SchemaName | NVARCHAR(128) | From sprockit.Process | ||
| ProcessName | NVARCHAR(128) | From sprockit.Process | ||
| FqProcessName | NVARCHAR(392) | From sprockit.Process | ||
| ProcessType | VARCHAR(4) | The object type of this process. | Object type values are as defined for sys.objects.[type] with the additional value 'SSIS' indicating that a process is an SSIS package. |
|
| IsStoredQuery | BIT | Indicates whether the process (in fact any object of this [ProcessType]) is a stored query. | e.g. a view or a function | |
| ObjectId | INT | The database-scoped object ID of this process object. | If applicable | |
| LatestExecutionId | INT | From sprockit.Process | ||
| Status | VARCHAR(20) | From sprockit.Process | ||
| LastStatusUpdate | DATETIME | From sprockit.Process | ||
| AvgDuration | INT | From sprockit.Process | ||
| BranchWeight | INT | From sprockit.Process | ||
| IsEnabled | BIT | From sprockit.Process | ||
| Priority | TINYINT | From sprockit.Process |
Relationships with integrity enforced by a foreign key constraint have identifiers prefixed with FK; others are prefixed RL.
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| RL1 | ProcessId | sprockit.Process | ProcessId |
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.