Page History

...

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_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_FILES

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_TYPE`	NOT NULL	VARCHAR			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_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
`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	HTTP port that the JobScheduler instance is listening to.
`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 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	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		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

...

Space shortcuts

Page tree

Versions Compared

Old Version 23

New Version 24

Key