Records the detailed status of the various utility jobs on Oracle RDBMS .
The jobs whose run history is tracked via this table are:
In schema versions prior to 3.50 the partitioning utility and review queue recorded detail status in tables WGN3PurgeState and WGN3queueState respectively, this single table replaces these older tables. Note also in previous releases that these tables only held status information from the most recent run, the new table holds information from multiple runs and individual runs can be identified by the log number column value.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|---|---|---|---|---|
|
Run Identifies a specific instance of a job that has run |
|
INTEGER |
|
|
|
Jobtype Identifies the type of job. |
|
INTEGER |
|
0 Partition Utility |
|
LogNum Identifies the specific log enabling entries to be retained over time. |
|
INTEGER |
|
Each job type defines how many logs to retain. |
|
Step Identifies the particular step performed. |
|
INTEGER |
5 |
|
|
STMT Uniquely identifies each statement. |
|
INTEGER |
5 |
A step can comprise multiple statements. |
|
Created Date and time the operation occurred |
|
TIMESTAMP |
|
|
|
Statement What the actual SQL DDL performed is. |
|
VARCHAR |
2000 |
Contains error message if the statement fails. |
|
Status Status of current statement. |
|
VARCHAR |
2000 |
Values are STARTED, COMPLETED, FAILED. |
To maintain compatibility with older releases views WGN3PURGESTATE and WGN3QUEUESTATE are introduced in schema version 3.50 to mimic the tables from previous release. These views only return rows of the appropriate type.
|
Copyright © 2014 CA.
All rights reserved.
|
|