Page History

...

Expand

title	INVENTORY_AGENT_CLUSTERMEMBERS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_INSTANCES.ID`
AGENT_CLUSTER_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_AGENT_CLUSTERS.ID`
AGENT_INSTANCE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_AGENT_INSTANCES.ID`
URL	NOT NULL	VARCHAR			agent url
ORDERING	NOT NULL	NUMERIC
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_AGENT_CLUSTERS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_INSTANCES.ID`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_PROCESS_CLASSES.ID`
SCHEDULING_TYPE	NOT NULL	VARCHAR
NUMBER_OF_AGENTS	NOT NULL	NUMERIC
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_AGENT_INSTANCES

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_INSTANCES.ID`
OS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_OPERATING_SYSTEMS.ID`
HOSTNAME	NOT NULL	VARCHAR
VERSION	NOT NULL	VARCHAR
URL		VARCHAR		X
STATE		NUMERIC
STARTED_AT		DATETIME
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_APPLIED_LOCKS

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`JOB_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_JOBS.ID`
LOCK_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_LOCKS.ID`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_INSTANCESFILES

HOSTNAMELIVE_DIRECTORY of the

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`SCHEDULERINSTANCE_ID`	NOT NULL	VARCHAR		corresponds to the `SCHEDULER_ID` that is specified during installation of the JobScheduler instance	NUMERIC	Foreign Key	X	references `INVENTORY_INSTANCES.ID`
`FILE_TYPE`	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. Should not TCP port be specified then the UDP port is provided.
	file types in use: `job` `job_chain` `order` file types not used: `process_class` `config` `lock` `schedule` `...`
`FILE_NAME`		NOT NULL	VARCHAR		X	path	from live directory e.g. `/test/my_job.job.xml`
`FILE_BASENAMECREATED`	NOT NULL	VARCHAR	DATETIME		timestamp of record creation	file base name with extension e.g. `my_job.job.xml`
`FILE_DIRECTORYMODIFIED`	NOT NULL	DATETIMEVARCHAR		timestamp of record modification

Expand

title	INVENTORY_FILES

	path calculated from the `live` directory e.g. `test`
`FILE_CREATED`	NULL	DATETIME	UTC timestamp of the creation date of the file
`FILE_MODIFIED`	NULL	DATETIME	UTC timestamp of the modification date of the file
`FILE_LOCAL_CREATED`	NULL	DATETIME	local timestamp of the creation date of the file
`FILE_LOCAL_MODIFIED`	NULL	DATETIME	local timestamp of the modification date of the file
`CREATED`	NOT NULL	DATETIME	UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME	UTC timestamp of record modification

Expand

title	INVENTORY_INSTANCES

Field	Nullable	Data type	Constraint	Unique Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
OS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_OPERATING_SYSTEMS.ID`
`SCHEDULER_ID`	NOT NULL	VARCHAR		X	corresponds to the `SCHEDULER_ID` that is specified during installation of the JobScheduler instance
`HOSTNAME`	NOT NULL	VARCHAR		X	host on which the JobScheduler instance has been installed
`PORT`	NOT NULL	NUMERIC		X	TCP port that the JobScheduler instance is listening to. Should not TCP port be specified then the UDP port is provided.
`LIVE_DIRECTORY`	NOT NULL	VARCHAR			path of the `live` directory
VERSION	NOT NULL	VARCHAR
COMMAND_URL	NOT NULL	VARCHAR
URL	NOT NULL	VARCHAR
TIMEZONE	NOT NULL	VARCHAR
CLUSTER_TYPE	NOT NULL	VARCHAR
PRECEDENCE		NUMERIC
DBMS_NAME	NOT NULL	VARCHAR
DBMS_VERSION		VARCHAR
STARTED_AT		DATETIME
SUPERVISOR_ID		NUMERIC
AUTH		VARCHAR
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_JOB_CHAIN_NODES

FILEpath from test/my_job.job.xml

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID`
JOB_ID	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOBS.ID`
`JOB_CHAIN_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
NESTED_JOB_CHAIN_ID	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_JOB_CHAINS.ID`
`NAME`	NOT NULL	VARCHAR		job node name: `file_order_source` `job_chain_node` `file_order_sink`
`ORDERING`	NOT NULL	NUMERIC		ordering of node in job chain
`STATE`		VARCHAR		job node state as specified in the configuration
`NEXT_STATE`		VARCHAR		next state for an order in case of successful execution
`ERROR_STATE`		VARCHAR		error state for an order in case of unsuccessful execution
`JOB`		VARCHAR		job name as specified in the job node configuration e.g. `../my_job`
`JOB`
Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID`
`FILE_TYPE`	NOT NULL	VARCHAR		file types in use: `job` `job_chain` `order` file types not used: `process_class` `config` `lock` `schedule` `...`
`_NAME`	NOT NULL	VARCHAR		Foreign Key	corresponds to `INVENTORY_JOBS.NAME.` Paths are resolved to absolute values starting from the `live` directory e.g.
`FILE_BASENAME`	NOT NULL	VARCHAR		file base name with extension e.g. `my_job.job.xml`
`FILE_DIRECTORY`	NOT NULL	VARCHAR		path calculated from the `live` directory e.g. `test`
`FILE_CREATED`	NULL	DATETIME		UTC timestamp of the creation date of the file
`FILE_MODIFIED`	NULL	DATETIME		UTC timestamp of the modification date of the file
`FILE_LOCAL_CREATED`	NULL	DATETIME		local timestamp of the creation date of the file
`/test/my_job`
NESTED_JOB_CHAIN		VARCHAR
NESTED_JOB_CHAIN_NAME	NOT NULL	VARCHAR	Foreign Key	corresponds to `INVENTORY_JOB_CHAINS.NAME`
NODE_TYPE	NOT NULL	NUMERIC
ON_ERROR		VARCHAR
DELAY		NUMERIC
DIRECTORY		VARCHAR
REGEX		VARCHAR
FILE_SINK_OP		NUMERIC
MOVE_PATH		VARCHAR			`FILE_LOCAL_MODIFIED`	NULL	DATETIME	local timestamp of the 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 Key
`INSTANCE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_INSTANCES.ID` used for simplified clean-up
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	references `INVENTORY_FILES.ID`
`NAME`	NOT NULL	VARCHAR		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
`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	REPORT_EXECUTION_SUMMARY

CREATE OR REPLACE FUNCTION REPORT_EXECUTION_SUMMARY(start_date DATE, end_date DATE) RETURNS TABLE ( 
    "ID"                    BIGINT,
    "SCHEDULER_ID"          VARCHAR(100),
    "HOSTNAME"              VARCHAR(255), 
    "JOB_CHAIN"             VARCHAR(255), 
    "JOB_NAME"              VARCHAR(255), 
    "JOB_BASENAME"          VARCHAR(100),
    "JOB_CHAIN_BASENAME"    VARCHAR(100),
    "JOB_TITLE"             VARCHAR(255),
    "JOB_CHAIN_TITLE"       VARCHAR(255),
    "CAUSE"                 VARCHAR(100),
    "IS_ACTIVE_CALENDAR"    INT,
    "START_TIME"            TIMESTAMP,
    "END_TIME"              TIMESTAMP,
    "START_DATE"            DATE,
    "END_DATE"              DATE
)

Space shortcuts

Page tree

Versions Compared

Old Version 5

New Version 6

Key