All jobs that shall be processed via the Empirum Interface Service must be entered into the table EmpTaskQueue. All mandatory fields must be set to execute a job. The following table elements are available:
| Name | Description/Value | Typ |
|---|---|---|
| ID | Unique ID for the job | E |
| ID_EmpExtSubscribers | Foreign key of the external system from the EmpExtSubscribers table to which the job has been assigned | M |
| Priority | Not used at the moment | - |
| Name | Job name | O |
| ActionType | Type of job (e.g., software distribution) | M |
| ActionCode | Job (e.g., install) | M |
| TargetObjectType | Target object (e.g., computer) | M |
| Status | Current job status. The initial status must be set to 1; it is changed automatically by Empirum. 1 = new 4 = running 5 = succesful 6 = failed |
M / E |
| AllOrNothing | Not used at the moment | E |
| InsertTimeStamp | Time stamp | E |
| ErrorCode | 0 = no error 1 =error |
E |
| ErrorText | Error message | E |
| LastUpdate | Last modification of the data (e.g., status change) | E |
Type: M = mandatory field, O = optional, E = set by Empirum, - = not used at the moment
Unique identification of each action is ensured through a combination of numbers, which must be entered into the table elements ActionType, ActionCode and TargetObjectType. Certain parameters must also be specified for each action in the EmpTaskParam table. The number combinations can be found in the detailed description of the respective function.
Example:
Action Assign computer to a configuration group:
| ID | ID_EmpExtSubscribers | Priority | Name | ActionType | ActionCode | TargetObjectType |
|---|---|---|---|---|---|---|
| 42> | 1 | NULL | Client1 | 5 | 10 | 1 |
| Status | AllOrNothing | InsertTimeStamp | ErrorCode | ErrorText | LastUpdate |
|---|---|---|---|---|---|
| 1 | NULL | 16.11.2007 15:51:40 | NULL | NULL |