Page History

CREATE OR REPLACE FUNCTION REPORT_INSTALLED_OBJECTS(start_date DATE, end_date DATE) RETURNS TABLE (
    "ID" BIGINT,
    "SCHEDULER_ID" VARCHAR(100),
    "HOSTNAME" VARCHAR(255),
    "JOB_CHAIN" VARCHAR(255), 
    "JOB_NAME" VARCHAR(255), 
    "JOB_BASENAME" VARCHAR(100),
    "JOB_CHAIN_BASENAME"    VARCHAR(100),
    "JOB_TITLE"             VARCHAR(255),
    "JOB_CHAIN_TITLE" VARCHAR(255),
    "CAUSE" VARCHAR(100),
    "IS_ACTIVE_CALENDAR" INT,
    "FILE_CREATED" TIMESTAMP,
    "FILE_MODIFIED" TIMESTAMP
)