Chapter 6: Managing Application Catalog Databases
Reference
422
ADS-0950-UG00
AdminStudio 9.5 User Guide
AsNotification
This table defines any message alerts associated with a job and sent via e-mail if the job is set to a particular status.
AsQueueStatus
This table contains the status ids for each state in which a job can be set to. Do not change this table.
Table 6-120 •
AsNotification Table Columns
Column
Type
Key
Nullabl
e
Description
NotificationI
d_
Int
Y
N
The primary key identifier of particular job notification
record.
SentTo
Varchar(400)
N
N
Self-explanatory
Subject
Varchar(100)
N
Y
Self-explanatory
Message
Varchar(800)
N
Y
Self-explanatory
StatusId_
Int
N
N
Foreign key into the
AsQueueStatus
table –
StatusId
column. Identifies the job status which is associated with
this notification record.
JobQueueId
_
Int
N
N
Foreign key into the
AsJobQueue
table –
JobQueueId
column. Identifies the job queue entry to which this
notification is associated.
Table 6-121 •
AsQueueStatus Table Columns
Column
Type
Key
Nullabl
e
Description
StatusId
Int
Y
N
The primary key identifier of particular job status value.
StatusName
Varchar(32)
N
N
A specific name for a given job status.
Description
Varchar(250)
N
N
A descriptive name for the job status
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...