– hosts ———————————————————————-

DO $$

BEGIN
  CREATE TYPE {SCHEMA_NAME}.host_statuses AS ENUM (
    'running',   -- host is running
    'shutdown',  -- host is shutting down
    'stopped'    -- host is not running
  );
EXCEPTION
  WHEN duplicate_object THEN RAISE DEBUG 'type {SCHEMA_NAME}.host_statuses already exists';
END;

$$;

– The hosts table records available hosts. hosts are the basis for the – sticky jobs feature - a sticky job is a job which can only be checked – out by a specific host.