Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Overview of the Adapter | Adapter Notifications | Polling Notifications and States
 
Polling Notifications and States
The following table summarizes the states in which polling notifications can exist and how they affect the triggers, buffer tables, and data processing of a polling notification.
State name
Status of trigger and buffer table when polling notification enters this state
Data processing while in this state
Comments
Enabled
Database trigger and buffer table are created.
The polling notification performs as scheduled.
Suspended
Database trigger and buffer table persist. Table retains its rows.
The polling notification is removed from the scheduler and does not execute while suspended. Any instances executing at the time the Suspended state is initiated are unaffected.
You can suspend polling notifications in an Enabled state. You cannot suspend polling notifications in a Disabled state.
You can copy or export suspended polling notifications. You cannot move, rename, or delete suspended polling notifications.
Disabled
Database trigger and buffer table are dropped.
The polling notification is removed from the scheduler and does not execute.
The table above applies to Insert Notifications, Update Notifications, Delete Notifications, and Ordered Notifications. However, the table does not apply to Basic Notifications or Stored Procedure Notifications because with these, the resource administrator (not Adapter for JDBC) is responsible for maintaining the trigger and buffer table.
For instructions on enabling, suspending, and disabling polling notifications, see the explanation of the State field in Managing Polling Notifications.