This table contains the list of agents in the Job manager. The structure of the table is as follows:
Fields
Name |
Description |
Type |
Lg. |
Dec* |
Key |
JOBID |
Internal Job manager ID for the report. |
NUM_BIN_4 |
9 |
0 |
1 |
NAME |
Name of the agent (unique secondary key). |
ALPHA |
50 |
0 |
|
DESCRIPTION |
Description of the agent. |
ALPHA |
250 |
0 |
|
STARTMODE |
Possible values: 'A' Started automatically with the Job manager. 'M' Started manually. 'D' Disabled. |
ALPHA |
1 |
0 |
|
STARTDATE |
Last start date. |
TIMESTAMP |
4 |
0 |
|
STOPDATE |
Last stop date. |
TIMESTAMP |
4 |
0 |
|
STATE |
Job state. Possible values: ' ' Agent stopped normally. 'E' Agent stopped with errors. 'W' Agent stopped with warnings. 'A' Agent is in the process of starting. 'R' Agent is currently running. 'S' Stop requested. |
ALPHA |
1 |
0 |
|
TARGETSERVER |
Requested execution server (Job manager name or blank). |
ALPHA |
250 |
0 |
|
EXECSERVER |
Execution server in progress (not relevant if stopped). |
ALPHA |
250 |
0 |
|
RESTARTCOUNT |
Number of failures permitted before restart attempts stop. |
NUM_BIN_2 |
4 |
0 |
|
FAILCOUNT |
Number of failures since the agent last started "normally". Reset to zero after the Job manager starts or command for manually starting the agent. If FailCount >= RestartCount, the agent is not restarted automatically in the event of failure. |
NUM_BIN_2 |
4 |
0 |
|
PGM |
Service program. |
ALPHA |
250 |
0 |
|
PARAM1 |
First parameter of the processing program. |
ALPHA |
1024 |
0 |
|
PARAM2 |
Second parameter of the processing program. |
ALPHA |
1024 |
0 |
|
STATUSTEXT |
Free text displayed in the console. It can be modified via API but is of no special significance for the Job manager. Reset to zero when the agent starts or stops. |
ALPHA |
250 |
0 |
|
PID |
Field: ID of the client process of the agent. |
NUM_BIN_4 |
9 |
0 |
|
* Decimals
Depending on the configuration, the Job manager may use different sets of tables, with or without schemas. For more information, see Deleting a schema.
