timeseries_views.bgw_job

Uqbar provides background task views, allowing you to view the status of the background tasks, such as periodical deletion and compression. The timeseries_views schema provides the bgw_job view, allowing you to view all time-series table policies.

Table 1 bgw_job columns

Field	Type	Description
objname	name	Name of the time-series table to which the task belongs.
type	name	Task type. Values: - r (retention) - c (compression) - s (continuous aggregation)
status	name	Current task status. Values: - running - finished - failed - disable
interval	text	Time expression for calculating the time when the job is to be run next time. The value can be an interval or sysdate plus a numeric value, for example, sysdate+1.0/24. If the value is empty or null, the job is run only once. After the job is executed, the job is in the d status and will not be run.
next_run_date	timestamp	Time when the task is executed next time. The value can be accurate to millisecond.
last_run_date	timestamp	Time when the task was executed last time. The value can be accurate to millisecond.
last_end_date	timestamp	Time when the task was finished last time. The value can be accurate to millisecond.
failure_count	smallint	Number of failure times. If the number of constant failure times reaches 16, the job will not be executed.