Provide technical information on the data model.
Users can use this information to create their own reports from the data model.

Standard Data Model

Inventory Tables

The following tables are managed by reporting inventory jobs that create an inventory of existing jobs, job chains and orders.
Records are overwritten by each run of the reporting inventory jobs.

...

Expand

title	REPORT_EXECUTIONS

Field	Nullable	Data type	Constraint	Description
`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`
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign Key	references `REPORT_TRIGGERS.ID`
`STEP`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_STEP_HISTORY.STEP`
`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`
`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
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC		specifies if a start time has been configured: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

...

Aggregation Tables

The following tables are used for the mapping of report data. Users can add individual records that are used for the mapping of results in individual reports:contain aggregations for
- job steps per order
- triggers and executions per day, week, month, quarter, year
- Mapping of start causes for jobs

Expand

title	REPORT_MAPTRIGGER_CAUSESRESULTS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`CAUSESCHEDULER_ID`	NOT NULL	VARCHAR		start cause as used by JobScheduler	corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_IDMAPPED_CAUSE`	NOT NULL	VARCHARNUMERIC		individual mapping of start cause	corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_IDCREATED`	NOT NULL	DATETIMENUMERIC		timestamp of record creation	Foreign Key	references REPORT_TRIGGERS.ID
`START_CAUSEMODIFIED`	NOT NULL	DATETIMEVARCHAR		timestamp of record modification

Aggregation Tables

The following tables contain aggregations for
- job steps per order
- triggers and executions per day, week, month, quarter, year

Expand

title	REPORT_TRIGGER_RESULTS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign Key	references REPORT_TRIGGERS.ID
`START_CAUSE`	NOT NULL	VARCHAR		references `SCHEDULER_HISTORY.CAUSE` of the first step for the value `order` check the start cause given in `INVENTORY_JOB_CHAINS.START_CAUSE`
`STEPS`	NOT NULL	NUMERIC		specifies the number of job steps that have been executed
`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
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

references `SCHEDULER_HISTORY.CAUSE` of the first step for the value `order` check the start cause given in `INVENTORY_JOB_CHAINS.START_CAUSE`
`STEPS`	NOT NULL	NUMERIC	specifies the number of job steps that have been executed
`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
`CREATED`	NOT NULL	DATETIME	timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME	timestamp of record modification

Expand

title	REPORT_EXECUTION_DATES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`REFERENCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `REPORT_TRIGGERS.ID` or `REPORT_EXECUTIONS.ID`
`REFERENCE_TYPE`	NOT NULL	NUMERIC		type of reference: `0:` references `REPORT_TRIGGERS` `1:` references `REPORT_EXECUTIONS`
`START_DAY`	NOT NULL	NUMERIC		calendar day e.g. 1
`START_WEEK`	NOT NULL	NUMERIC		calendar week e.g. 52
`START_MONTH`	NOT NULL	NUMERIC		calendar month e.g. 12
`START_QUARTER`	NOT NULL	NUMERIC		quarter e.g. 1
`START_YEAR`	NOT NULL	NUMERIC		year e.g. 2015
`END_DAY`	NOT NULL	NUMERIC		calendar day e.g. 1
`END`

Expand

title	REPORT_EXECUTION_DATES

STARTNUMERIC

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_ID`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`REFERENCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `REPORT_TRIGGERS.ID` or `REPORT_EXECUTIONS.ID`
`REFERENCE_TYPE`	NOT NULL	NUMERIC		type of reference: `0:` references `REPORT_TRIGGERS` `1:` references `REPORT_EXECUTIONS`
`START_DAY`	NOT NULL	NUMERIC		calendar day e.g. 1
`START_WEEK`	NOT NULL	NUMERIC		calendar week e.g. 52
`STARTEND_MONTH`	NOT NULL	NUMERIC		calendar month e.g. 12
`STARTEND_QUARTER`	NOT NULL	NUMERIC		quarter e.g. 1
`END_YEAR`	NOT NULL	NUMERIC		calendar year e.g. 2015 `END_DAY`
`CREATED`	NOT NULL	DATETIME		calendar day e.g. 1
`END_WEEK`	NOT NULL	NUMERIC		calendar week e.g. 52
`END_MONTH`	NOT NULL	NUMERIC		calendar month e.g. 12
timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Mapping Tables

The following tables are used for the mapping of report data. Users can add individual records that are used for the mapping of results in individual reports:
- Mapping of start causes for jobs
Contents in these tables is optional, however, their existence is required.
- Sample content: report_map_insert.sql

Expand

title	REPORT_MAP_CAUSES

Field	Nullable	Data type	Description
`IDEND_QUARTER`	NOT NULL	NUMERIC	quarter e.g. 1
`END_YEAR`	NOT NULL	NUMERIC	calendar year e.g. 2015
Primary Key
`CAUSE`	NOT NULL	VARCHAR	start cause as used by JobScheduler: possible values include `order`: job start triggered by manual order `min_tasks`: job start triggered by forced minimum number of tasks `delay_after_error`: job start due to a setback event `period_single`: job start triggered by order start time `period_repeat`: job start triggered by order repeat interval `queue_at`: job start scheduled manually or by task congestion additional values provided by the JobScheduler Reporting Interface include `file_trigger`: job start due to an incoming file
`MAPPED_CAUSE`	NOT NULL	VARCHAR	individual mapping of start cause
`CREATED`	NOT NULL	DATETIME	timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME	timestamp of record modification

...

timestamp of record modification

Customization

The standard data model can be customized by use of additional tables and procedures.
Such tables are not required by the JobScheduler Reporting Interface.

Sample Tables

The following tables are used implement samples for the customization of reports. Users can add individual records that are used for the mapping of results in individual reports:
Mapping of applications to jobs

Mapping of mandators to jobs

:

Assigning applications to jobs
Assigning mandators to jobs

Samples are presented for instructional use only.

Custom Jobs

Status
colour Red
title TODO
Clarify removal of this sample

Expand

title	REPORT_CUSTOM_APPSJOBS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`NAME`	NOT NULL	VARCHAR		application name
`TITLE`	NULL	VARCHAR		application title
		job name
`TITLE`	NULL	VARCHAR		job title

Assigning Applications to Jobs

Should a report present information on a number of jobs that are used for the same application then the following tables could be used:

Application Master Data

Expand

title	REPORT_CUSTOM_JOBSAPPS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`NAME`	NOT NULL	VARCHAR		job application name
`TITLE`	NULL	VARCHAR		job application title

Application Joins to Jobs

Expand

title	REPORT_CUSTOM_MANDATORSJOB_APPS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`JOB_NAME`	NOT NULL	VARCHAR		mandator name	`TITLE`	`corresponds to INVENTORY_JOBS.NAME`
`APP_NAME`	NOT NULL	VARCHAR	mandator title	corresponds `REPORT_CUSTOM_APPS.NAME`

Assigning Mandators to Jobs

Mandator Master Data

Expand

title	REPORT_CUSTOM_JOB_APPSMANDATORS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`JOB_NAME`	NOT NULL	VARCHAR		`corresponds to INVENTORY_JOBS.NAME`	`APP_NAME`	mandator name
`TITLE`	NOT NULL	VARCHAR	corresponds `REPORT_CUSTOM_APPS.NAME`	mandator title

Mandator Joins to Jobs

Expand

title	REPORT_CUSTOM_JOB_MANDATORS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`JOB_CHAIN`	NOT NULL	VARCHAR	Foreign Key	references `REPORT_JOBS.ID`
`MANDATOR_ID`	NOT NULL	NUMERIC	Foreign Key	references `REPORT_MANDATOR.ID`

Space shortcuts

Page tree

Versions Compared

Old Version 5

New Version 6

Key

Standard Data Model

Inventory Tables

Aggregation Tables

Aggregation Tables

Mapping Tables

Customization

Sample Tables

Custom Jobs

Assigning Applications to Jobs

Application Master Data

Application Joins to Jobs

Assigning Mandators to Jobs

Mandator Master Data

Mandator Joins to Jobs

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 5

New Version 6

Key

Standard Data Model

Inventory Tables

Aggregation Tables

Aggregation Tables

Mapping Tables

Customization

Sample Tables

Custom Jobs

Assigning Applications to Jobs

Application Master Data

Application Joins to Jobs

Assigning Mandators to Jobs

Mandator Master Data

Mandator Joins to Jobs