Previous Topic: Abandon_RunNext Topic: Wgn3QueueState and Wgn3JobState


Wgn3QueueHistory and Wgn3JobHistory

On SQL Server, the Wgn3QueueHistory table records key metrics about each run of the Review Queue process.

On Oracle, the actual data is stored in a generic table called WGN3JobHistory along with other job types. Review Queue entries can be identified as having a JOBTYPE = 1. Wgn3QueueHistory is actually a view that returns only those entries where JOBTYPE =1. This provides compatibility with older versions, where WGN3QueueHistory existed as a table on Oracle.

Note: In this release there is an anomaly between the Oracle and SQL Server implementations, because WGN3QueueHistory is still a table in SQL Server databases.