Page History

...

Expand

title	REPORTING_TRIGGERS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	VARCHAR		X	corresponds to `SCHEDULER_ORDER_HISTORY.SPOOLER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		X	corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`NAME`	NOT NULL	VARCHAR			corresponds to `SCHEDULER_ORDER_HISTORY.ORDER_ID` e.g. `my_order` for a given order path `/test/my_jobchain,my_order.order.xml`
`TITLE`		VARCHAR			order title corresponds to `INVENTORY_JOB_CHAIN_ORDERS.TITLE`
PARENT_FOLDER	NOT NULL	VARCHAR			job chain folder e.g. `/test` for a given job chain path `/test/my_jobchain.job_chain.xml`
`PARENT_NAME`	NOT NULL	VARCHAR			job chain name corresponds to `SCHEDULER_ORDER_HISTORY.JOB_CHAIN` e.g. `/test/my_jobchain` for a given job chain path `/test/my_jobchain.job_chain.xml`
`PARENT_BASENAME`		VARCHAR			job chain base name e.g. `my_jobchain` for a given job chain path `/test/my_jobchain.job_chain.xml`
`PARENT_TITLE`		VARCHAR			job chain title corresponds to `INVENTORY_JOB_CHAINS.TITLE`
STATE		VARCHAR			state of the order inside the job chain corresponds to `SCHEDULER_ORDER_HISTORY.STATE`
STATE_TEXT		VARCHAR			state text of the order corresponds to `SCHEDULER_ORDER_HISTORY.STATE_TEXT`
`START_TIME`	NOT NULL	DATETIME			UTC timestamp of the start of the order corresponds to `SCHEDULER_ORDER_HISTORY.START_TIME`
`END_TIME`		DATETIME			UTC timestamp of the end of the order corresponds to `SCHEDULER_ORDER_HISTORY.END_TIME`
IS_RUNTIME_DEFINED	NOT NULL	NUMERIC				specifies if a start time has been configured: `1: yes` `0: no` corresponds to `INVENTORY_ORDERS.IS_RUNTIME_DEFINED`
RESULT_START_CAUSE	NOT NULL	VARCHAR			cause of the order start order file_trigger ... corresponds to `INVENTORY_JOB_CHAINS.START_CAUSE`
RESULT_STEPS	NOT NULL	NUMERIC			number of executed order steps
RESULT_ERROR	NOT NULL	NUMERIC			specifies if an error occurred in the last executed order step: `0: no error` `1: error`
RESULT_ERROR_CODE		VARCHAR			exception-code of the last executed order step error
RESULT_ERROR_TEXT		VARCHAR			exception-message of the last executed order step error
`SYNC_COMPLETED`	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a synchronization has been completed: `1: yes` `0: no`
`RESULTS_COMPLETED`	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a aggregation has been completed: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	REPORTING_EXECUTIONS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	NUMERIC		X	corresponds to `SCHEDULER_ORDER_HISTORY.SPOOLER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		X	corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `REPORT_TRIGGERS.ID`
TASK_ID	NOT NULL	NUMERIC	Foreign Key		references `REPORT_TASKS.ID`
CLUSTER_MEMBER_ID		VARCHAR			corresponds to `SCHEDULER_HISTORY.CLUSTER_MEMBER_ID`
`STEP`	NOT NULL	NUMERIC		X	consecutive number of the order step corresponds to `SCHEDULER_ORDER_STEP_HISTORY.STEP`
FOLDER	NOT NULL	VARCHAR			folder of the order step e.g. `/test` for a given job chain path `/test/my_jobchain.job_chain.xml`
`NAME`	NOT NULL	VARCHAR			job name of the order step corresponds to `SCHEDULER_HISTORY.JOB_NAME` e.g. `/test/my_job`
`BASENAME`	NOT NULL	VARCHAR			job base name of the order step e.g. `my_job`, for a given job path `/test/my_job.job.xml`
`TITLE`	NULL	VARCHAR			job title of the order step corresponds to `INVENTORY_JOBS.TITLE`
`START_TIME`	NOT NULL	DATETIME			UTC timestamp of the start of the order step corresponds to `SCHEDULER_ORDER_STEP_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME			UTC timestamp of the end of the order step corresponds to `SCHEDULER_ORDER_STEP_HISTORY.END_TIME`
`STATE`	NOT NULL	VARCHAR			state of the order inside the job chain corresponds to `SCHEDULER_ORDER_STEP_HISTORY.STATE`
`CAUSE`	NOT NULL	VARCHAR			start cause for execution, can be mapped to an individual start cause by use of table REPORT `REPORTING_MAP_CAUSES` corresponds to `SCHEDULER_HISTORY.CAUSE`
EXIT_CODE	NOT NULL	NUMERIC			corresponds to `SCHEDULER_HISTORY.EXIT_CODE`
`ERROR`	NOT NULL	NUMERIC			specifies if an error occurred: `0: no error` `1: error` corresponds to `SCHEDULER_ORDER_STEP_HISTORY.ERROR`
`ERROR_CODE`	NULL	VARCHAR		JobScheduler	exception-code of the order step error corresponds to `SCHEDULER_ORDER_STEP_HISTORY.ERROR_CODE` error code
`ERROR_TEXT`	NULL	VARCHAR		error	exception-message of the order step error corresponds to `SCHEDULER_ORDER_STEP_HISTORY.ERROR_TEXT` message
AGENT_URL		VARCHAR			agent url corresponds to `SCHEDULER_HISTORY.AGENT_URL`
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC			specifies if a start time has been configured: `1: yes` `0: no: no` corresponds to `INVENTORY_JOBS.IS_RUNTIME_DEFINED`
SYNC_COMPLETED	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a synchronization has been completed: `1: yes` `0: no`
RESULTS_COMPLETED	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a aggregation has been completed: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

...

Expand

title	REPORTING_TASKS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	NUMERIC		X	corresponds to `SCHEDULER_HISTORY.SPOOLER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		X	corresponds to `SCHEDULER_HISTORY.ID`
IS_ORDER	NOT NULL	NUMERIC			cause for execution of the task: `1: order task` `0: standalone task`
CLUSTER_MEMBER_ID		VARCHAR			corresponds to `SCHEDULER_HISTORY.CLUSTER_MEMBER_ID`
`STEPS`	NOT NULL	NUMERIC			number of steps --> calls to spooler_process() corresponds to `SCHEDULER_HISTORY.STEPS`
FOLDER	NOT NULL	VARCHAR			job folder e.g. `/test`, for a given job path `/test/my_job.job.xml`
`NAME`	NOT NULL	VARCHAR			job name corresponds to `SCHEDULER_HISTORY.JOB_NAME` e.g. `/test/my_job`
`BASENAME`	NOT NULL	VARCHAR			job base name e.g. `my_job`, for a given job path `/test/my_job.job.xml`
`TITLE`	NULL	VARCHAR			corresponds to `INVENTORY_JOBS.TITLE`
`START_TIME`	NOT NULL	DATETIME			corresponds to `SCHEDULER_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME			corresponds to `SCHEDULER_HISTORY.END_TIME`
`CAUSE`	NOT NULL	VARCHAR			corresponds to `SCHEDULER_HISTORY.CAUSE` start cause for execution, can be mapped to an individual start cause by use of table `REPORT_MAP_CAUSES`
EXIT_CODE	NOT NULL	NUMERIC			corresponds to `SCHEDULER_HISTORY.EXIT_CODE`
`ERROR`	NOT NULL	NUMERIC			specifies if an error occurred: `0: no error` `1: error`
`ERROR_CODE`	NULL	VARCHAR			JobScheduler error code
`ERROR_TEXT`	NULL	VARCHAR			error message
AGENT_URL		VARCHAR			corresponds to `SCHEDULER_HISTORY.AGENT_URL`
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC			specifies if a start time has been configured: `1: yes` `0: no`
SYNC_COMPLETED	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a synchronization has been completed: `1: yes` `0: no`
RESULTS_COMPLETED	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a aggregation has been completed: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

...

Expand

title	REPORT_EXECUTION_SUMMARY

CREATE OR REPLACE FUNCTION REPORT_EXECUTION_SUMMARY(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,
    "START_TIME"            TIMESTAMP,
    "END_TIME"              TIMESTAMP,
    "START_DATE"            DATE,
    "END_DATE"              DATE
)

Space shortcuts

Page tree

Versions Compared

Old Version 16

New Version 17

Key