GJSJOBS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EXECUTIONID varchar 45 null
GJSLOGS.EXECUTIONID FKGJSLOGS_GJSJOBSR
GJSPARAMETERS.EXECUTIONID FKGJSPARAMETERS_GJSJOBSR
ACTIONNAME varchar 120 √ null
USERNAME varchar 20 null
REQUESTEDAT datetime 16,3 √ null
STARTEDAT datetime 16,3 √ null
STATUS int 4 √ null
STATUSDESC varchar 20 √ null
ERRORINFO MEMO 2147483647 √ null
SCHEDULEDTO datetime 16,3 √ null
PROCESSNAME varchar 60 √ null
PROGRESS int 4 √ null
PARAMCLASSNAME varchar 200 √ null
PARAMASSEMBLYNAME varchar 200 √ null
HOSTNAME varchar 30 √ null
FINISHEDAT datetime 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKGJSJOBS Primary key Asc EXECUTIONID

Relationships

Close relationships within degrees of separation