Alerter Object Types and Stored Procedures
If you use an alerter as the polling method, object types and stored procedures are available for committing messages. The following table lists the available object types and stored procedures.
Name | Type | Description |
---|---|---|
adb_alerter_qtbl (Oracle only) | AQ queue table | Queue table for all alerters. |
adb_alerter_q (Oracle only) | AQ queue | Queue for all alerters. |
adb_alerter_typ | Service Broker Message Type | Object type for all messages. |
adb_alerter_contract
(Microsoft SQL Server 2005 only) |
Service Broker Contract | The contract type used. The contract specifies the message types that can be used. |
instance_Id_q
(Microsoft SQL Server 2005 only) |
Service Broker Queue | Created by the config_alerter stored procedure. |
instance_Id_send_service
(Microsoft SQL Server 2005 only) |
Service Broker Service | Created by the config_alerter stored procedure. |
instance_Id_rcv_service
(Microsoft SQL Server 2005 only) |
Service Broker Service | Created by the config_alerter stored procedure. |
adb_alerter_typ | Object | Object type for the payload message. |
commit_and_notify | Procedure | Sends a change notification to all adapters. |
commit_and_notify_agent
alerter_name |
Procedure | Sends a change notification to the named alerter. |
commit_and_notify_table
table_name |
Procedure | Sends a change notification for a named table. |
stop_alerter | Procedure | Stops all running alerters. |
stop_alerter_agent
alerter_name |
Procedure | Stops the alerter for the named alerter. |
config_alerter | Procedure | Alerter call to register itself as an AQ subscriber. |
cleanup_alerter | Procedure | Alerter call to unregister itself as an AQ subscriber. |
listen_pipe | Procedure | Alerter call to block on alerts. |
Copyright © Cloud Software Group, Inc. All rights reserved.