ml_ra_get_agent_events system procedure

Syntax	Description
start_at_event_id	BIGINT. This is an IN parameter that specifies the ID of the event from which to start the query.
max_events_to_fetch	BIGINT. This is an IN parameter that specifies the maximum number of events to fetch.

Result	Description
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 types are listed below. ANEW A new agent was defined in the consolidated database. This can occur by calling ml_ra_add_agent or if the agent is not preconfigured when the agent connects to the consolidated database for the first time. AFIRST Occurs on the first synchronization of an agent. ADUP A duplicate agent_id was found, meaning two or more agents are trying to use the same ID. The result_text for this is the remote_id of the blocked agent's agent database. ARESET An agent rebuilt its agent database. Some task progress and results may have been lost. TB A task has begun execution. TE The task execution ended without a fatal error. TW A task execution is waiting for a retry interval before continuing. TAC Task execution ended because a command aborted. TAT Task execution ended because it exceeded the maximum allowed running time. TAR Task execution ended because it exceeded the maximum retry count. TFS The task completed and will not run again because it was a run-once task that succeeded. TFF The task completed and will not run again because it was a run-once task that failed. TFE The task completed and will not run again because the schedule for the task has expired. TFC The task completed and will not run again because the task was canceled by the server. CR - Command Result The result_code and result_text are populated with values specific to the type of command. CE - Command Error The result_code and result_text are populated with values specific to the type of command.
agent_id	VARCHAR(128). The ID of the agent that produced this event.
remote_id	VARCHAR(128). The ID of the remote database that the event applies to. This is only set for task-related events that target a specific remote database.
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.

Alternatively you can use the ml_ra_get_task_results procedure, which only fetches events related to a specific run of a task. You can pass in a null @run_number to get the latest run of a task.

One way to use this procedure is to use ml_ra_get_agent_events to wait for a task-end event (TE) then call ml_ra_get_task_results to get each of the command results that might need processing.

ml_ra_get_agent_events system procedure

Parameters

Returns

Remarks

See also