The Agents table stores actions that automatically run Basic scripts, SQL scripts, or remote tasks for Remote users. Agents are created using the Administrator and require an agent name, sync server, scheduling details, description, ability to enable the agent, and other information.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
AGENTID (PK) |
STANDARDID |
NOT NULL |
AGENTS_AGENTSID_PK (CA) |
|
|
|
AGENTNAME |
varchar(32) |
NULLS |
|
|
|
|
ENABLED |
BOOLEAN |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
USERID (FK) |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
GROUPID |
STANDARDID |
NULLS |
|
(Many) to (One) |
|
|
HOSTID |
STANDARDID |
NULLS |
|
|
|
|
NEXTRUN |
datetime |
NULLS |
|
|
|
|
PERIOD |
int |
NULLS |
|
|
|
|
PERIODSPEC |
int |
NULLS |
|
|
|
|
PERIODDATA |
int |
NULLS |
|
|
|
|
ITERATIONS |
int |
NULLS |
|
|
|
|
DATA |
Datablob |
NULLS |
|
|
|
|
|
varchar(255) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |