The information related to the status of the query is stored in the QT_QUERY_INSTANCE table.
QT_QUERY_INSTANCE |
|
|
|
Key |
Column Name |
Column Definition |
Nullable? |
PK |
QUERY_INSTANCE_ID |
Unique id for the query |
NO |
FK |
QUERY_MASTER_ID |
Many to one reference to the query master table |
NO |
|
USER_ID |
The user's login id |
NO |
|
GROUP_ID |
The project id |
NO |
|
BATCH_MODE |
The name of the queue in which the query is running or last ran |
YES |
|
START_DATE |
The date the query was started (run) |
YES |
|
END_DATE |
The date the query finished running |
YES |
|
DELETE_FLAG |
A flag that denotes whether or not the query was deleted. (Y / N) |
NO |
FK |
STATUS_TYPE_ID |
Reference to the QT_STATUS_TYPE table |
NO |
|
Message |
To store the query error message, warning, etc. |
YES |