Table of Contents

Scope

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

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	INVENTORY_INSTANCES

Field Nullable Data type Constraint Description

ID NOT NULL NUMERIC Primary keyKey

SCHEDULER_ID NOT NULL VARCHAR corresponds to the SCHEDULER_ID that is specified during installation of the JobScheduler instance

HOSTNAME NOT NULL VARCHAR host on which the JobScheduler instance has been installed

PORT

NOT NULL

NUMERIC

TCP port that the JobScheduler instance is listening to

Status

colour	Red
title	to be discussed

TCP, UDP Port

extra

in separate columns? yes.

LIVE_DIRECTORY NOT NULL VARCHAR path of the live directory

CREATED NOT NULL DATETIME timestamp of record creation

MODIFIED NOT NULL DATETIME timestamp of record modification

Expand

title	INVENTORY_FILES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_INSTANCES.ID`
`FILE_TYPE`	NOT NULL	VARCHAR		file types in use: `job` `job_chain` `order` Not treatedfile types not used: `process_class` `config` `lock` `schedule` `...`
`FILE_NAME`	NOT NULL	VARCHAR		Path path from live directory e.g. `test/my_job.job.xml`
`FILE_BASENAME`	NOT NULL	VARCHAR		file base name File basename e.g. `my_job.job.xml`
`FILE_DIRECTORY`	NOT NULL	VARCHAR		Path path calculated from the `live` directory e.g. `test`
`FILE_CREATED`	NULL	DATETIME		UTC time timestamp of the creation date of the file
`FILE_MODIFIED`	NULL	DATETIME		UTC time timestamp of the last change modification date of the file
`FILE_LOCAL_CREATED`	NULL	DATETIME		Local time local timestamp of the creation date of the file
`FILE_LOCAL_MODIFIED`	NULL	DATETIME		Local time local timestamp of the last change modification date of the file
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Expand

title	INVENTORY_JOBS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_INSTANCES.ID` for easy cleanupused for simplified clean-up
`FILE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_FILES.ID`
`NAME`	NOT NULL	VARCHAR		Job job name e.g. `test/my_job` for a given job (path`test/my_job.job.xml)`
`BASENAME`	NOT NULL	VARCHAR		Job job base name e.g. `my_job` for a given job (path `test/my_job.job.xml)`
`TITLE`	NULL	VARCHAR		job title
`IS_ORDER_JOB`	NOT NULL	NUMERIC		specifies if this job is part of a job chain: `1: yes` `0: no`
`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

Expand

title	INVENTORY_JOB_CHAINS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_INSTANCES.ID` for easy cleanupused for simplified clean-up
`FILE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_FILES.ID`
`START_CAUSE`	NOT NULL	VARCHAR		the following start causes are available: `file trigger` `order` ...
`NAME`	NOT NULL	VARCHAR		Job job chain name e.g. `test/my_jobchain (` for a given job chain path`test/my_jobchain.job_chain.xml)`
`BASENAME`	NOT NULL	VARCHAR		Job job chain base name e.g. `my_jobchain (` for a given job chain path `test/my_jobchain.job_chain.xml)`
`TITLE`	NULL	VARCHAR		job chain title
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Expand

title	INVENTORY_JOB_CHAIN_NODES

Field Nullable Data type Constraint Description

ID NOT NULL NUMERIC Primary keyKey

INSTANCE_ID

NOT NULL

NUMERIC

Foreign keyKey

references INVENTORY_INSTANCES.ID

for easy cleanupused for simplified clean-up

JOB_CHAIN_ID NOT NULL NUMERIC Foreign keyKey references INVENTORY_JOB_CHAINS.ID

NAME

NOT NULL

VARCHAR

job node name:

file_order_source
job_chain_node

Status

colour	Red
title	to be discussed

Eventuell

possibly add end nodes such as END_NODE ...?

ORDERING NOT NULL NUMERIC Node order ordering of node in job chain

STATE

NULL

VARCHAR

job node state as specified in the configuration

NEXT_STATE NULL VARCHAR next state for an order in case of successful execution

ERROR_STATE NULL VARCHAR error state for an order in case of unsuccessful execution

JOB

NULL

VARCHAR

job reference as specified in the job node configuration

e.g. ../my_job

JOB_NAME

NOT NULL

VARCHAR

Foreign keyKey

corresponds to INVENTORY_JOBS.NAME

e.g. test/my_job

CREATED NOT NULL DATETIME timestamp of record creation

MODIFIED NOT NULL DATETIME timestamp of record modification

Expand

title	INVENTORY_JOB_CHAIN_ORDERS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references`INVENTORY_INSTANCES.ID` `for easy cleanupused for simplified clean-up`
`FILE_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `INVENTORY_FILES.ID`
`JOB_CHAIN_NAME`	NOT NULL	VARCHAR	Foreign keyKey	corresponds to `INVENTORY_JOB_CHAINS.NAME` e.g. `test/my_jobchain`
`ORDER_ID`	NOT NULL	VARCHAR		order identification (unique per job chain) Order name e.g. `my_order (` for a given job chain path`test/my_jobchain,my_order.order.xml)`
`TITLE`	NULL	VARCHAR		order title
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC		specifies if a start time has been configured: `1: yes` `no` `0: no`
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Fact Tables

The following tables are used to collect facts from the JobScheduler history.
These tables can be used to create individual reports.

Status

colour	Red
title	to be discussed

Eine neue extra Tabelle

Use of a separate table REPORT_TRIGGER_

...

CONFIGURATIONS for job chains including the PARENT_xxx

...

columns?

??

Expand

title	REPORT_TRIGGERS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`SCHEDULER_ID`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`NAME`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.ORDER_ID`
`TITLE`	NULL	VARCHAR		Titleorder title corresponds to `INVENTORY_JOB_CHAIN_ORDERS.TITLE`
`PARENT_NAME`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.JOB_CHAIN`
`PARENT_BASENAME`	NULL	VARCHAR		Job job chain basenamebase name
`PARENT_TITLE`	NULL	VARCHAR		corresponds to `INVENTORY_JOB_CHAINS.TITLE`
`START_TIME`	NOT NULL	DATETIME		corresponds to `SCHEDULER_ORDER_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME		corresponds to `SCHEDULER_ORDER_HISTORY.END_TIME`
`SYNC_COMPLETED`	NOT NULL	NUMERIC		specifies if a synchronization has been configured and has been completed successfully: `1: yes` `0: no` 0 1
`RESULTS_COMPLETED`	NOT NULL	NUMERIC		0 specifies if all job nodes have been completed successfully: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Expand

title	REPORT_EXECUTIONS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`SCHEDULER_ID`	NOT NULL	NUMERIC	Foreign keyKey	corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC	Foreign keyKey	corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `REPORT_TRIGGERS.ID`
`STEP`	NOT NULL	NUMERIC		Sequence of steps 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 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
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Custom Tables

The following tables are used for 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
- Mapping of start causes for jobs

Expand

title	REPORT_APPS

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

Expand

title	REPORT_JOBS

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

Expand

title	REPORT_MANDATORS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`NAME`	NOT NULL	VARCHAR		mandator name
`TITLE`	NULL	VARCHAR		mandator title

Expand

title	REPORT_MAP_JOB_APPS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`JOB_ID`	NOT NULL	VARCHAR	Foreign key Key	references `REPORT_JOBS.ID`
`APPLICATION_ID`	NOT NULL	NUMERIC	Foreign keyKey	references `REPORT_APPLICATIONS.ID`

Expand

title	REPORT_MAP_JOB_MANDATORS

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

Expand

title	REPORT_MAP_CAUSES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`CAUSE`	NOT NULL	VARCHAR		start cause as used by JobScheduler
`MAPPED_CAUSE`	NOT NULL	VARCHAR		individual mapping of start cause

Aggregation Tables

Expand

title	REPORT_TRIGGER_RESULTS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary keyKey
`TRIGGER_ID`	NOT NULL	NUMERIC	Foreign keyKey	Reference to the references REPORT_TRIGGERS.ID
`START_CAUSE`	NOT NULL	VARCHAR		references `SCHEDULER_HISTORY.CAUSE` of the 1.st first step if equals `"order"` check in the for the value `order` check the start cause given in `INVENTORY_JOB_CHAINS.START_CAUSE`
`STEPS`	NOT NULL	NUMERIC		Number specifies the number of steps that have been effected: `SCHEDULER_ORDER_STEP_HISTORY.STEP` of the last step or `1` for not order standalone jobs
`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 keyKey
`REFERENCE_ID`	NOT NULL	NUMERIC	Foreign keyKey	Reference to the 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 calendar day e.g. 1
`START_WEEK`	NOT NULL	NUMERIC		Calendar calendar week e.g. 52
`START_MONTH`	NOT NULL	NUMERIC		Calendar calendar month e.g. 12
`START_QUARTER`	NOT NULL	NUMERIC		Quarterquarter e.g. 1
`START_YEAR`	NOT NULL	NUMERIC		Yearyear e.g. 2015
`END_DAY`	NOT NULL	NUMERIC		Calendar calendar day e.g. 1
`END_WEEK`	NOT NULL	NUMERIC		Calendar calendar week e.g. 52
`END_MONTH`	NOT NULL	NUMERIC		Calendar calendar month e.g. 12
`END_QUARTER`	NOT NULL	NUMERIC		Quarterquarter e.g. 1
`END_YEAR`	NOT NULL	NUMERIC		Calendar calendar year e.g. 2015
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Space shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key

Scope

Data Model

Inventory Tables

Fact Tables

Custom Tables

Aggregation Tables

Space shortcuts

Page tree

Page History

Versions Compared

Old Version 1

New Version 2

Key

Scope

Data Model

Inventory Tables

Fact Tables

Custom Tables

Aggregation Tables