Page History

...

Expand

title	REPORT_MAP_CAUSES

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`CAUSE`	NOT NULL	VARCHAR		start cause as used by JobScheduler
`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

Custom Tables (Samples)

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

Aggregation Tables

Expand

title	REPORT_CUSTOMTRIGGER_APPSRESULTS

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

Expand

title	REPORT_CUSTOM_JOBS

TITLE

Field	Nullable	Data type	Constraint	Description
corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`TRIGGER_`
`ID`	NOT NULL	NUMERIC	Primary Foreign Key		references REPORT_TRIGGERS.ID
`START_CAUSENAME`	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		job name	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		job title

Expand

title	REPORT_CUSTOM_MANDATORS

Field	Nullable	Data type	Constraint	Description
JobScheduler error code
`ERROR_TEXT`	NULL	VARCHAR		error message
`CREATED`
`ID`	NOT NULL	NUMERIC	Primary Key
`NAME`	NOT NULL	VARCHARDATETIME		mandator name	`TITLE`	timestamp of record creation
`MODIFIED`	NOT NULL	VARCHARDATETIME	mandator title	timestamp of record modification

Expand

title	REPORT_CUSTOMEXECUTION_JOB_APPSDATES

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

Expand

title	REPORT_CUSTOM_JOB_MANDATORS

IDMANDATOR.ID

Field	Nullable	Data type	Constraint	Description
`SCHEDULER_ID`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_`
`ID`	NOT NULL	NUMERIC	Primary Key		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
`REFERENCE_ID`		`JOB_CHAIN`	NOT NULL	VARCHARNUMERIC	Foreign Key	references `REPORT_` JOBS `TRIGGERS.ID` or `REPORT_EXECUTIONS.ID` MANDATOR
`REFERENCE_`	`TYPE`	NOT NULL	NUMERIC			type of reference: `0:`	Foreign Key	references `REPORT_`

Aggregation Tables

TRIGGERS
1: references REPORT_EXECUTIONS

START_DAY

NOT NULL

NUMERIC

calendar day

e.g. 1

START_WEEK

Expand

title	REPORT_TRIGGER_RESULTS

SCHEDULER_IDVARCHARHISTORY_IDSTART_CAUSEVARCHARERROR

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key			calendar week e.g. 52
`START_MONTH`		NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`	calendar month e.g. 12
`START_QUARTER`	NOT NULL	NUMERIC			quarter e.g. 1
`START_YEAR`	corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`	`TRIGGER_ID`	NOT NULL	NUMERIC		Foreign Key	references REPORT_TRIGGERS.ID	year e.g. 2015
`END_DAY`	NOT NULL	NUMERIC		references `SCHEDULER_HISTORY.CAUSE` of the first step for the value `order` check the start cause given in `INVENTORY_JOB_CHAINS.START_CAUSE`	calendar day e.g. 1
`END_WEEK`	`STEPS`	NOT NULL	NUMERIC		specifies the number of job steps that have been executed		calendar week e.g. 52
`END_MONTH`		NOT NULL	NUMERIC		specifies if an error occurred `0: no error` `1: error`
`ERROR_CODE`	NULL	VARCHAR		JobScheduler error code
calendar month e.g. 12
`END_QUARTER`	NOT NULL	NUMERIC		quarter e.g. 1
`END_YEAR`	NOT NULL	NUMERIC		calendar year e.g. 2015	`ERROR_TEXT`	NULL	VARCHAR		error message
`CREATED`	NOT NULL	DATETIME		timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		timestamp of record modification

Custom Tables (Samples)

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

Expand

title	REPORT_EXECUTIONCUSTOM_DATESAPPS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULER_IDNAME`	NOT NULL	VARCHAR		corresponds to `SCHEDULER_ORDER_HISTORY.SCHEDULER_ID`
`HISTORY_ID`	NOT NULL	NUMERIC		corresponds to `SCHEDULER_ORDER_HISTORY.HISTORY_ID`
application name
`TITLE`	NULL	VARCHAR		application title

Expand

title	REPORT_CUSTOM_JOBS

REFERENCE_REFERENCE_TYPENUMERIC

Field Nullable Data type Constraint Description

ID

NOT NULL

NUMERIC

Foreign Primary Key

references REPORT_TRIGGERS.ID or REPORT_EXECUTIONS.ID

NAME

NOT NULL

VARCHAR

type of reference:

0: references REPORT_TRIGGERS
1: references REPORT_EXECUTIONS

job name

TITLE NULL VARCHAR job title

Expand

title	REPORT_CUSTOM_MANDATORS

NUMERIC

Field	Nullable	Data type	Constraint	Description
`ID`
`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	Primary Key		calendar month e.g. 12	`START_QUARTER`
`NAME`	NOT NULL	VARCHAR		quarter e.g. 1	`START_YEAR`	NOT NULL	mandator name
`TITLE`	NULL	VARCHARNUMERIC		year e.g. 2015	mandator title

Expand

title	REPORT_CUSTOM_JOB_APPS

END_MONTHNUMERICEND_QUARTERNUMERIC

Field	Nullable	Data type	Constraint	Description
`ID`
`END_DAY`	NOT NULL	NUMERIC		calendar day e.g. 1
`END_WEEK`	NOT NULL	NUMERIC		calendar week e.g. 52	Primary Key
`JOB_NAME`	NOT NULL	VARCHAR		calendar month e.g. 12	`corresponds to INVENTORY_JOBS.NAME`
`APP_NAME`		NOT NULL	VARCHAR		corresponds `REPORT_CUSTOM_APPS.NAME`

Expand

title	REPORT_CUSTOM_JOB_MANDATORS

Field Nullable Data type Constraint Description

ID

quarter

e.g. 1

END_YEAR

NOT NULL

NUMERIC

calendar year

e.g. 2015

Primary Key

JOB_CHAINCREATED NOT NULL DATETIMEVARCHAR timestamp of record creation Foreign Key references REPORT_JOBS.ID

MANDATOR_IDMODIFIED NOT NULL DATETIMENUMERIC Foreign Key references REPORT_MANDATOR.IDtimestamp of record modification

Space shortcuts

Page tree

Versions Compared

Old Version 3

New Version 4

Key

Custom Tables (Samples)

Custom Tables (Samples)