Use this procedure to check the status of tasks.
Parameters| Syntax | Description |
|---|---|
|
agent_id |
VARCHAR(128). This is an IN parameter that specifies the ID of the agent you want to get status for. |
|
task_name |
VARCHAR(128). This is an IN parameter that specifies the name of the task you want to get status for. |
Returns| Result | Description |
|---|---|
|
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. |
|
task_name |
VARCHAR(128). The name of the task. |
| task_id |
BIGINT. The task ID. |
|
state |
VARCHAR(4). The state of the deployed task. State can be one of the following:
|
|
reported_exec_count |
BIGINT. The reported number of tasks that have been executed. |
|
reported_error_count |
BIGINT. The reported number of errors. |
|
reported_attempt_count |
BIGINT. The reported number of attempts to execute a task. |
|
last_status_update |
TIMESTAMP. The time the last status update was given. |
|
last_success |
TIMESTAMP. The time of the last successful task. |
|
assignment_time |
TIMESTAMP. The time the task was assigned. |
|
p_crsr |
SYS_REF_CURSOR. This is an OUT parameter for Oracle only. |
RemarksThe @agent_id and @task_name parameters can be set to null to get the status for all agent_ids, all task_names or both.
The reported_attempt_count may be greater than the reported_exec_count so the precondition on the task evaluated to false on an attempt and the task did not execute.
The success count can be computed by subtracting reported_error_count from reported_exec_count.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |