You use Ordered Notifications to monitor multiple insert, update, or delete operations on one or more tables for a given database by creating a single notification using the same publishable document. Similar to Insert Notifications, Update Notifications, and Delete Notifications, Ordered Notifications use triggers and buffer tables to capture events that happen on specific tables in a database.

After you enable the Ordered Notification, the trigger, buffer table, and sequence remain in the database table when you:

In the meantime, the trigger continues to monitor the table and to insert data into the buffer table. Integration Server invokes the enabled Ordered Notification when it restarts, or when it enables or reloads the package that contains this notification.

When you disable a notification, the adapter drops the trigger, the buffer table, and the sequence.

For more information about how Ordered Notifications work, see Ordered Notifications Transaction Processing.