zz$gauge

From zzat
Jump to: navigation, search

zz$gauge stores the main gauge attributes, such as their schedule.

It has the following columns:

Column Name Data Type Description
zz$db number Database DBID from zz$db.
name varchar2 Name of the gauge. Limited to 13 characters. The name, together with zz$db form the unique row identifier.
metric varchar2 Name of the metric the gauge is for. Corresponds to zz$metric.name.
job# number Used to generate job names when creating jobs for the gauge. Ensures job names are unique.
comments varchar2 Describes what the gauge is for.
query CLOB The base gauge SQL statement to execute when the gauge runs.
flags number Flags configure the behavior of the gauge.
gauge_interval number For standard gauges, this defines the scheduler interval. Combined with gauge_unit this forms the calendaring syntax that runs the gauge. The expression is formed like this:

FREQ={gauge_unit};INTERVAL={gauge_interval}

gauge_unit varchar2 For standard gauges, this defines the scheduler interval. Combined with gauge_interval this forms the calendaring syntax that runs the gauge. Valid values are SECOND,MINUTE,HOUR,DAY,MONTH,YEAR. Singular or plural forms are allowed.
gauge_volume interval_day_to_second The default volume of the gauge, specified as an interval.
last_successful_run timestamp Timestamp in UTC of the last time this gauge ran successfully (with exit code 0).
last_sync timestamp Currently unused.
warn_reaction varchar2 The name of the reaction or reaction chain to fire when this gauge detects a warning condition
crit_reaction varchar2 The name of the reaction or reaction chain to fire when this gauge detects a critical condition.
warn_message varchar2 The header or title message to pass to the reaction. Accepts substitution variables.
crit_message varchar2 The header or title message to pass to the reaction. Accepts substitution variables.
gauge_hash raw Auto-generated hash that changes when the gauge has been changed. Used for gauge synchronization from the repository to targets.
gauge_date date Auto-generated date that changes when the gauge or any dependent attributes (columns, ignores, overrides, etc) have been changed. Used for gauge synchronization from the repository to targets.