1-- Add new monitoring columns to JOBS Table
2
3alter table jobs
4    add column log_critical_count integer CHECK (log_critical_count >= 0),
5    add column log_error_count integer CHECK (log_error_count >= 0),
6    add column log_warning_count integer CHECK (log_warning_count >= 0),
7    add column log_info_count integer CHECK (log_info_count >= 0),
8    add column parent integer;