Page History

...

The following tables are used to collect facts from the JobScheduler history.
No standalone jobs are given. Fact tables contain job chain starts exclusively.
These tables can be used to create individual reports.
SQL Scripts
- Tables: reporting.sql

Expand

title	REPORTREPORTING_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.SCHEDULERSPOOLER_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`
`TITLE`	NULL	VARCHAR			order title corresponds to `INVENTORY_JOB_CHAIN_ORDERS.TITLE`
PARENT_FOLDER	NOT NULL	VARCHAR
`PARENT_NAME`	NOT NULL	VARCHAR			corresponds to `SCHEDULER_ORDER_HISTORY.JOB_CHAIN`
`PARENT_BASENAME`	NULL	VARCHAR			job chain base name
`PARENT_TITLE`	NULL	VARCHAR			corresponds to `INVENTORY_JOB_CHAINS.TITLE`	`START_TIME`	NOT NULL
STATE		VARCHAR	DATETIME		corresponds to
STATE_TEXT		VARCHAR
`START_TIME`	NOT NULL	DATETIME			corresponds to `SCHEDULER_ORDER_HISTORY.START_TIME`
SCHEDULER_ORDER_HISTORY.START_TIME`END_TIME`	NULL	DATETIME			corresponds to `SCHEDULER_ORDER_HISTORY.END_TIME`
SYNC IS_RUNTIME_ COMPLETED DEFINED	NOT NULL	NUMERIC		for use by the JobScheduler Reporting Interface jobs only: specifies if a synchronization has been configured and has been completed successfully: `1: yes` `0: no`
RESULT_START_CAUSE `RESULTS_COMPLETED`	NOT NULL	NUMERICVARCHAR
RESULT_STEPS	for use by the JobScheduler Reporting Interface jobs only: specifies if all job nodes have been completed successfully: `1: yes` `0: no`	`CREATED`	NOT NULL	NUMERIC	DATETIME
RESULT_ERROR	timestamp of record creation	`MODIFIED`	NOT NULL	DATETIMENUMERIC		timestamp of record modification

Expand

title	REPORT_EXECUTIONS

Field	Nullable	Data type	Constraint	Description

RESULT_ERROR_CODE		VARCHAR
RESULT_ERROR_TEXT		VARCHAR
`SYNC_COMPLETED`
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	NUMERIC		corresponds to SCHEDULER_ORDER_HISTORY.SCHEDULER_ID
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
	for use by the JobScheduler Reporting Interface only: specifies if a synchronization has been completed: `1: yes` `0: no`
`RESULTS_COMPLETEDTRIGGER_ID`	NOT NULL	NUMERIC		Foreign Key	references `REPORT_TRIGGERS.ID`	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	corresponds to `SCHEDULER_ORDER_STEP_HISTORY.STEP`
FOLDER	NOT NULL	VARCHAR
`NAME`	NOT NULL	VARCHAR			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_ORDER_STEP_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME			corresponds to `SCHEDULER_ORDER_STEP_HISTORY.END_TIME`
`STATE`	NOT NULL	VARCHAR			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_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	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
CLUSTER_MEMBER_ID		VARCHAR			corresponds to `SCHEDULER_HISTORY.CLUSTER_MEMBER_ID`
`STEPS`	NOT NULL	NUMERIC			corresponds to `SCHEDULER_HISTORY.STEPS`
FOLDER	NOT NULL	VARCHAR
`NAME`	NOT NULL	VARCHAR			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
`STEP`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_STEP_HISTORY.STEP`
`NAME`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_HISTORY.JOBEND_NAME` e.g. `test/my_job` `TIME`
`CAUSEBASENAME`	NOT NULL	VARCHAR		job base name e.g. `my_job`, for a given job path `test/my_job.job.xml`		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		`TITLE`	NULL	VARCHAR	corresponds to `INVENTORYSCHEDULER_JOBSHISTORY.TITLEEXIT_CODE`
`ERRORSTART_TIME`	NOT NULL	NUMERIC	DATETIME		corresponds to `SCHEDULER_ORDER_STEP_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME		corresponds to `SCHEDULER_ORDER_STEP_HISTORY.END_TIME`
`STATE`	NOT NULL	VARCHAR		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_MAP_CAUSES`
`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
	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 `IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC			for use by the JobScheduler Reporting Interface only: specifies if a start time aggregation has been configuredcompleted: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			timestamp of record modification

...

Space shortcuts

Page tree

Versions Compared

Old Version 13

New Version 14

Key