Before Starting an Alerter

When using an alerter with an Oracle database, ensure that you run the create_user.sql and alerter.sql files with the database account used by the adapter, as described in "Post-Installation Tasks" in TIBCO ActiveMatrix Adapter for Database (TIBCO Business Studio) Installation.

When using an alerter with a Microsoft SQL Server database, ensure that you run the create_user70.sql and alerter_ms.sql files with the database account used by the adapter. You also have to ensure that the Service Broker function is enabled on the database server.

To check whether the Service Broker function is enabled, run the following statement:

SELECT is_broker_enabled FROM sys.databases WHERE database_id = DB_ID()

The returned value is 1.

To enable the Service Broker function, run the following statement:

Alter database dbname set enable_broker with rollback immediate