Page History

...

Expand

title	REPORTING_TRIGGERS

Contains the informations about executed job chains and orders.

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

Contains the informations about executed order steps.

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 `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			exception-code of the order step error corresponds to `SCHEDULER_ORDER_STEP_HISTORY.ERROR_CODE`
`ERROR_TEXT`	NULL	VARCHAR			exception-message of the order step error corresponds to `SCHEDULER_ORDER_STEP_HISTORY.ERROR_TEXT`
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` 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

Contains the informations about executed job 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`, for a given job path `/test/my_job.job.xml`
`BASENAME`	NOT NULL	VARCHAR			job base name e.g. `my_job`, for a given job path `/test/my_job.job.xml`
`TITLE`	NULL	VARCHAR			job title corresponds to `INVENTORY_JOBS.TITLE`
`START_TIME`	NOT NULL	DATETIME			UTC timestamp of the task start corresponds to `SCHEDULER_HISTORY.START_TIME`
`END_TIME`	NULL	DATETIME			UTC timestamp of the task end corresponds to `SCHEDULER_HISTORY.END_TIME`
`CAUSE`	NOT NULL	VARCHAR			cause of the task start e.g. : none period_once period_single period_repeat job_repeat queue queue_at directory signal delay_after_error 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`
`ERROR_CODE`	NULL	VARCHAR			exception-code of the task error
`ERROR_TEXT`	NULL	VARCHAR			exception-message of the task error
AGENT_URL		VARCHAR			agen 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` 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

...

SELECT <fields> FROM REPORT_EXECUTION_SUMMARY('2017-05-01','2017-06-01');

following fields can be selected:
- ID
- SCHEDULER_ID
- HOSTNAME
- AGENT_URL
- JOB_CHAIN
- JOB_CHAIN_BASENAME
- JOB_CHAIN_TITLE
- JOB_NAME
- JOB_BASENAME
- JOB_TITLE
- CAUSE
- IS_ACTIVE_CALENDAR
- START_TIME
- END_TIME
- START_DATE
- END_DATE

Space shortcuts

Page tree

Versions Compared

Old Version 21

New Version 22

Key