Database Collection Agent Events(3.2)
Agent Message Events
An information message from the agent, stated according to the configuration done in the Event Notification Editor.
For further information about the agent message event type, see Agent Event(3.0).
Ready with table:
tablename
Reported, along with the name of the working table, when all rows are collected from it.
Debug Events
Debug messages are dispatched in debug mode. During execution, the messages are displayed in the Workflow Monitor.
You can configure Event Notifications that are triggered when a debug message is dispatched. For further information about the debug event type, see Debug Event(3.0).
The agent produces the following debug events:
Start collecting
Indicates that possible cleanup procedures are finalized and that the actual collection begins.
No rows selected from tableÂ
tablename
Reported, along with the name of the working table, if no rows have been selected for collection.
Avoids reading the following pending txn ids:Â
list of ids
Reported, along with a list of Transaction IDs, if the constructed SQLÂ
select
 statement finds any pending Transaction IDs in the pending transaction table. Rows marked with these transaction IDs will be excluded by the query.Marking collected data as cancelled
Reported when a Cancel Batch is received.
Deleting collected data
Reported when collected rows are removed after collection, if Remove is selected in After Collection.
Has deletedÂ
n
rows inÂtablename
Subevent to theÂ
Deleting collected data
 event, stating the number of rows removed by each SQLÂcommit
 command. The maximum number depends on the Commit Window Size.Marking collected data
Reported when collected rows are marked, if Mark as Collected is selected in After Collection.
Has updatedÂ
n
rows inÂtablename
Subevent to theÂ
Marking collected data
 event, stating the number of rows marked as collected by each SQLÂcommit
 command.Taking care of collected data viaÂ
SPname
Reported, along with the name of the stored procedure, when it is called after collection, if After Collection.
 is selected inÂTry to force running Stored Procedure to Stop
Reported when stopping a workflow that has a Stored Procedure running.
Agent Message Events
An information message from the agent, stated according to the configuration done in the Event Notification Editor.
For further information about the agent message event type, see Agent Event(3.0).
Ready with table:
tablename
Reported, along with the name of the working table, when all rows are collected from it.
Debug Events
Debug messages are dispatched in debug mode. During execution, the messages are displayed in the Workflow Monitor.
You can configure Event Notifications that are triggered when a debug message is dispatched. For further information about the debug event type, see Debug Event(3.0).
The agent produces the following debug events:
Start collecting
Indicates that possible cleanup procedures are finalized and that the actual collection begins.
No rows selected from tableÂ
tablename
Reported, along with the name of the working table, if no rows have been selected for collection.
Avoids reading the following pending txn ids:Â
list of ids
Reported, along with a list of Transaction IDs, if the constructed SQLÂ
select
 statement finds any pending Transaction IDs in the pending transaction table. Rows marked with these transaction IDs will be excluded by the query.Marking collected data as cancelled
Reported when a Cancel Batch is received.
Deleting collected data
Reported when collected rows are removed after collection, if Remove is selected in After Collection.
Has deletedÂ
n
rows inÂtablename
Subevent to theÂ
Deleting collected data
 event, stating the number of rows removed by each SQLÂcommit
 command. The maximum number depends on the Commit Window Size.Marking collected data
Reported when collected rows are marked, if Mark as Collected is selected in After Collection.
Has updatedÂ
n
rows inÂtablename
Subevent to theÂ
Marking collected data
 event, stating the number of rows marked as collected by each SQLÂcommit
 command.Taking care of collected data viaÂ
SPname
Reported, along with the name of the stored procedure, when it is called after collection, if After Collection.
 is selected inÂTry to force running Stored Procedure to Stop
Reported when stopping a workflow that has a Stored Procedure running.