You can also track the execution of background jobs by inspecting the BGPLOG table. The BGPLOG table holds detailed entries from the background processes including informational, elapsed time, and error entries. Refer to the BGPLOG Table Descriptions for information about what this table contains.
Column | Description | Value |
BGPLOG Table Descriptions | ||
|---|---|---|
Log_time | Time when background process made a log entry | Datetime |
Source | Program generating log entry | "system_monitor", "data_monitor" |
Type | Type of message | INFORMATION, ELAPSED TIME, ERROR |
Description | Message from the background process | A variable message followed by a number in parenthesis that represents the number of rows that processed. As an example, the message "Complete BGPLOG (40)" indicates that forty rows processed. |