Chapter 6: Managing Application Catalog Databases
Reference
AdminStudio 9.5 User Guide
ADS-0950-UG00
421
AsJobStepMaster
This table contains the job step type identification information.
AsJobQueueStepDetail
This table contains the individual job step statuses for the last run of any given job.
Table 6-118 •
AsJobStepMaster Table Columns
Column
Type
Key
Nullab
le
Description
StepId_
Int
Y
N
The primary key identifier of particular job step type.
JobName
Varchar(30)
N
N
A specific name for a given job step type.
JobStepDescripti
on
Varchar(100
)
N
N
A descriptive name for the job step type.
Table 6-119 •
AsJobQueueStepDetail Table
Column
Type
Key
Nullab
le
Description
JobQueueId_
Int
Y
N
Primary key into the AsJobQueue table – JobQueueId
column. Identifies the job queue entry which was
executed to generate this job step status.
JobStepId_
Int
Y
N
Primary key into the AsJobStep table – JobStepId
column. Identifies the particular job step.
RunOn
Datetime
N
Y
The time when this job step completed its execution.
LastOperatio
n
Varchar(200)
N
N
The last message generated by this particular job step.
StatusId_
Int
N
N
Foreign key into the
AsQueueStatus
table –
StatusId
column. Describes the specific status of this particular
job step.
ReportData
Varchar(4000
)
N
N
Extended job step specific data which describes how the
job was processed.
Summary of Contents for ADMINSTUDIO 9.5
Page 1: ...AdminStudio 9 5 User Guide Version 9 5...
Page 50: ...Contents 50 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 52: ...52 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 156: ...156 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 440: ...440 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1090: ...1090 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1426: ...1426 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1686: ...1686 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1794: ...Chapter 24 AdminStudio Public API Reference 1794 ADS 0950 UG00 AdminStudio 9 5 User Guide...
Page 1842: ...Index 1842 ADS 0950 UG00 AdminStudio 9 5 User Guide...
