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 references `INVENTORY_AGENT_INSTANCES.URL`
ORDERING	NOT NULL	NUMERIC			Order of agents in remote_schedulers element
`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			type of scheduling configured for the agent cluster `first` Fixed Priority Scheduling `next` Round Robin Scheduling `single`
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_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 HTTP 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			JobScheduler version e.g. 1.11.0
COMMAND_URL	NOT NULL	VARCHAR			HTTP URL for XML request response
URL	NOT NULL	VARCHAR			TCP URL still used by supervisor
TIMEZONE	NOT NULL	VARCHAR
CLUSTER_TYPE	NOT NULL	VARCHAR			possible values PRECEDENCE standalone active passive
PRECEDENCE			NUMERIC			precendence of JobScheduler in a passive cluster e.g. 0 (primary) , 1 (backup no. 1), 2 (backup no. 2) etc
DBMS_NAME	NOT NULL	VARCHAR			name of the database vendor e.g. MySql , Oracle, etc
DBMS_VERSION		VARCHAR			release number of database system
STARTED_AT		DATETIME
SUPERVISOR_ID		NUMERIC			reference `INVENTORY_INSTANCES.ID`
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

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`
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_NAME`	NOT NULL	VARCHAR			corresponds to `INVENTORY_JOBS.NAME.` Paths are resolved to absolute values starting from the `live` directory e.g. `/test/my_job`
NESTED_JOB_CHAIN		VARCHAR			job_chain attribute of the node
NESTED_JOB_CHAIN_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_JOB_CHAINS.NAME`
NODE_TYPE	NOT NULL	NUMERIC				specifies the node type: `1: job` `2: job chain` `3: file order source` `4: file order sink` `5: end node`
ON_ERROR		ON_ERROR		VARCHAR			on_error attribute of a job_chain_node
DELAY		NUMERIC			delay attribute of a job_chain_node
DIRECTORY		VARCHAR			directory attribute of a file_order_source
REGEX		VARCHAR			regex attribute of a file_order_source
FILE_SINK_OP		NUMERIC			specifies the operation in case of file order sink : `1: move` `2: remove`
MOVE_PATH		VARCHAR			in case of file order sink and operation move this column will have the directory path `e.g. /data/input/archive`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_JOB_CHAINS

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`
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
FW_PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
`START_CAUSE`	NOT NULL	VARCHAR			the following start causes are available: `file_trigger` `order`
`NAME`	NOT NULL	VARCHAR			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 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
MAX_ORDERS		NUMERIC			max_orders allowed in the job chain, default is unlimited
DISTRIBUTED	NOT NULL	NUMERIC				specifies if job chain is configured for cluster operation : `1: yes` `0: no`
PROCESS_CLASS		VARCHAR			process_class attribute of job chain
PROCESS_CLASS_NAME	NOT NULL	VARCHR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME`
FW_PROCESS_CLASS		VARCHAR			file_watching_process_class attribute of job chain
FW_PROCESS_CLASS_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_JOBS

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`
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
PROCESS_CLASS_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_PROCESS_CLASSES.ID`
SCHEDULE_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_SCHEDULES.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`
USED_IN_JOB_CHAINS		NUMERIC			count of how many job chain use this job
PROCESS_CLASS		VARCHAR			process_class attribute of job
PROCESS_CLASS_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_PROCESS_CLASSES.NAME`
SCHEDULE		VARCHAR			schedule attribute of job's runtime
SCHEDULE_NAME	NOT NULL	VARCHAR			corresponds to `INVENTORY_SCHEDULES.NAME`
`MAX_TASKS`	NOT NULL	NUMERIC				SCHEDULE_NAME	NOT NULL	max_task configured for the job, default is 1
`HAS_DESCRIPTION`		NUMERICVARCHAR		corresponds to `INVENTORY_SCHEDULES.NAME`	indicates if a job has associated documentation e.g. JITL job documentation or custom documentation from user `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_LOCKS

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`
FILE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
NAME	NOT NULL	VARCHAR			lock file name
BASENAME	NOT NULL	VARCHAR			lock base name
MAX_NON_EXCLUSIVE		NUMERIC			if `max_non_exclusive` is null `max_non_exclusive` is set to unlimited
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_OPERATING_SYSTEMS

Field	Nullable	Data type	Constraint	Description
`ID`	NOT NULL	NUMERIC	Primary Key
`HOSTNAME`	NOT NULL	VARCHAR			the host name where JobScheduler is installed
NAME		VARCHAR		name of the operating system `e.g. Windows, Linux, AIX, Solaris, other`
ARCHITECTURE		VARCHAR		x64/x32
DISTRIBUTION		VARCHAR		OS distribution name `e.g. Windows 2012, CentOS Linux release 7.2.1511 (Core)`
`CREATED`	NOT NULL	DATETIME		UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME		UTC timestamp of record modification

Expand

title	INVENTORY_ORDERS

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`
`FILE_ID`	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
JOB_CHAIN_ID	NOT_NULL	NUMERIC	Foreign Key		references `INVENTORY_JOB_CHAINS.ID`
SCHEDULE_ID	NOT_NULL	NUMERIC	Foreign Key		references `INVENTORY_SCHEDULES.ID`
`NAME`	NOT NULL	VARCHAR			order name e.g. `/test/my_jobchain,my_order` for a given order path /`test/my_jobchain,my_order.order.xml`
`BASENAME`	NOT NULL	VARCHAR			order base name e.g. `my_jobchain,my_order` for a given job chain path `/test/my_jobchain,my_order.order.xml`
`TITLE`	NULL	VARCHAR			order title
`ORDER_ID`	NOT NULL	VARCHAR			order identification (unique per job chain) e.g. `my_order` for a given order path`/test/my_jobchain,my_order.order.xml`
`JOB_CHAIN_NAME`	NOT NULL	VARCHAR			corresponds to `INVENTORY_JOB_CHAINS.NAME` e.g. `/test/my_jobchain`
SCHEDULE		VARCHAR			schedule attribute of order's runtime
SCHEDULE_NAME	NOT_NULL	VARCHAR			corresponds to `INVENTORY_SCHEDULES.NAME`
INITIAL_STATE		VARCHAR			the name of the start node
END_STATE		VARCHAR			the name of the end node
PRIORITY		NUMERIC			priority of the order
`IS_RUNTIME_DEFINED`	NOT NULL	NUMERIC			specifies if a start time has been configured: `1: yes` `0: no`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_PROCESS_CLASSES

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`
FILE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
NAME	NOT NULL	VARCHAR			process class file name
BASENAME	NOT NULL	VARCHAR			process class base name
MAX_PROCESSES		NUMERIC			max parallel execution of the task
HAS_AGENTS	NOT NULL	NUMERIC			specifies if an agent has been configured in the process class: 0: no `1: yes`
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

Expand

title	INVENTORY_SCHEDULES

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`
FILE_ID	NOT NULL	NUMERIC	Foreign Key	X	references `INVENTORY_FILES.ID`
SUBSTITUTE_ID	NOT NULL	NUMERIC	Foreign Key		references `INVENTORY_SCHEDULES.ID`
NAME	NOT NULL	VARCHAR			schedule file name
BASENAME	NOT NULL	VARCHAR			schedule base name
TITLE		VARCHAR			schedule's title
SUBSTITUTE		NUMERIC			substitute attribute
SUBSTITUTE_NAME	NOT NULL	NUMERIC			full path of the substituted schedule, references `INVENTORY_SCHEDULES.NAME`
SUBSTITUTE_VALID_FROM		DATETIME			timestamp "from" when SUBSTITUTE will be valid
SUBSTITUTE_VALID_TO		DATETIME			timestamp "to" until SUBSTITUTE will be valid
`CREATED`	NOT NULL	DATETIME			UTC timestamp of record creation
`MODIFIED`	NOT NULL	DATETIME			UTC timestamp of record modification

...

Space shortcuts

Page tree

Versions Compared

Old Version 22

New Version 23

Key