agent_id

VARCHAR(128). This is an IN parameter that specifies the ID of the agent you want to get results for.

task_name

VARCHAR(128). This is an IN parameter that specifies the name of the task you want to get results for.

run_number

INTEGER. This is an IN parameter that specifies the run number you want results for.

event_id

BIGINT. A unique ID assigned to each event. The value is incremented by 1 for each new event.

event_class

VARCHAR(1). The event class. The class can be either I for information or E for error.

event_type

VARCHAR(8). The event type.

agent_id

VARCHAR(128). The ID of the agent that produced this event.

remote_id

task_name

VARCHAR(128). The name of the task. This is only set for task-related events.

command_number

INTEGER. The command number within a task that this event applies to. This is only set for command-specific events.

run_number

BIGINT. The unique number assigned to each run of a task. This is only set for task-specific events.

duration

INTEGER. The amount of time taken by the event. This is only set for command-specific events.

event_time

TIMESTAMP. The time the event took place. For most events the time is based on the clock of the computer the agent is executing on.

event_received

TIMESTAMP. The time the event was received by the server. This is always set from the clock of the consolidated database.

result_code

BIGINT. An event-specific BIGINT. For example, for a SQL query command result, the code would be the SQLCODE.

result_text

LONG VARCHAR. An event-specific LONG VARCHAR. For example, for a SQL query command result, this column would contain a CSV format of the result set.

p_crsr

SYS_REF_CURSOR. This is an OUT parameter for Oracle only.