Maintains a history of various utilities that run 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 history in tables WGN3PurgeHistory and WGN3queueHistory respectively, this single table replaces these older tables.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|---|---|---|---|---|
|
Jobtype The type of job |
|
INTEGER |
10 |
0 Partition Utility |
|
Process The identifier of the process being run |
|
INTEGER |
10 |
The process that is being run, this is specific to the job type. |
|
Run Unique identifier of a particular job. |
Yes |
INTEGER |
10 |
|
|
Step The last step executed |
|
INTEGER |
5 |
Internal, used to determine where a failed purge will restart from. |
|
StartTime The time when the step started. |
|
TIMESTAMP |
|
|
|
EndTime The time when the step completed. |
|
TIMESTAMP |
|
|
|
D1 -5 5 date columns for recording job specific date values |
|
TIMESTAMP |
|
. |
|
N1-10 10 numeric columns for recording job specific numeric values |
|
INTEGER |
10 |
|
|
C1-5 5 character columns for recording job specific character values |
|
VARCHAR |
30 |
|
|
Status The status of the job |
|
VARCHAR |
30 |
COMPLETED, RESTARTED, STARTED or FAILED |
To maintain compatibility with older releases views WGN3PURGEHISTORY and WGN3QUEUEHISTORY 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.
|
|