iConsole Review Queue Guide › Manage the Review Queue › Wgn3QueueState and Wgn3JobState

Wgn3QueueState and Wgn3JobState

This database table records detailed information about each step performed in the last (current) run of the Review Queue process.

Note: If the Review Queue process fails with an error that can be trapped, the error text is written to this table as the failing statement.

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

Also, WGN3JobState now holds details of each step performed for multiple invocations of the Review Queue, and they can identified as such by the Run column. This is an enhancement to WGNQueueState, which previously only held information for the last run.

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