QUEUEPROCESSRESULT
Stores information about queue process runs.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| STEPNUMBER |
int |
|
Default = 0 |
|
| PARAMETERSETID |
uniqueidentifier |
yes |
|
|
| COMPLETIONCODE |
tinyint |
|
Default = 0 |
0=Completed, 1=Did not complete |
| COMPLETION |
nvarchar(16) (Computed) |
yes |
CASE [COMPLETIONCODE] WHEN 0 THEN N'Completed' WHEN 1 THEN N'Did not complete' END |
Provides a translation for the 'COMPLETIONCODE' field. |
| COMPLETIONMESSAGE |
nvarchar(1000) |
|
Default = '' |
|
| STARTDATE |
datetime |
yes |
|
|
| ENDDATE |
datetime |
yes |
|
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_QUEUEPROCESSRESULT_BUSINESSPROCESSCATALOGID |
BUSINESSPROCESSCATALOGID |
|
|
|
| IX_QUEUEPROCESSRESULT_BUSINESSPROCESSSTATUSID |
BUSINESSPROCESSSTATUSID |
|
|
|
| PK_QUEUEPROCESSRESULT |
ID |
yes |
yes |
yes |