sprockit.uvw_ProcessDependency
[ v1.3 ] [ v1.4 ] [ v1.5 ] [ Back to Sprockit home page ]
This view returns process dependencies inferred from configured resource dependencies.
A process dependency is a requirement that two processes be run in a specific order; i.e. A must run before B, and not B before A. The view refers to the process that must run first as the predecessor and the later process as the successor.
Sprockit stores dependency information in the form of resource dependencies because they are easier to configure, but process handlers need process dependency information to determine when a process is ready for execution. This view performs a self-join on sprockit.Resource, joining output resources to their subsequent use as input resources, inferring an execution dependency between the associated processes.
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| RL1 | PredecessorId | INT | Identifies the predecessor process | |
| PredecessorFqName | NVARCHAR(392) | The predecessor process's three-part name | From sprockit.Process | |
| PredecessorStatus | VARCHAR(20) | The predecessor process's status | From sprockit.Process | |
| RL2 | SuccessorId | INT | Identifies the successor process | |
| SuccessorFqName | NVARCHAR(392) | The successor process's three-part name | From sprockit.Process | |
| SuccessorStatus | VARCHAR(20) | The successor process's status | From sprockit.Process |
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 | PredecessorId | sprockit.Process | ProcessId |
| RL2 | SuccessorId | sprockit.Process | ProcessId |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.