create table sys_srv(
  sys_srv_id varchar(40) not null primary key,
  srv_name varchar(20),
  cmd varchar(80),
  dayofweek varchar(7),
  timedef varchar(250),  
  description varchar(80),
  single_next char(1),
  status int,
  datechg date,
  usrchg varchar(40),
  progchg varchar(40)
);


create table sys_srv_log(
  sys_srv_log_id varchar(40) not null primary key,
  sys_srv_id varchar(40) not null,
  cstart date,
  cnt_error int,
  cnt_warning int,
  cnt_ops int,
  status int,
  datechg date,
  srv_name varchar(20)
);


create table sys_srv_log_line(
  sys_srv_log_line_id varchar(40) not null primary key,
  sys_srv_log_id varchar(40) not null,
  typ char(1) not null,
  logtext varchar(250),
  lfdnr int,
  datechg date,
  srv_name varchar(20)
);

========================================================
























