Chapter 4: Real Time Stored Procedures for Administration  sp_msgadmin 'help'

Chapter 4: Real Time Stored Procedures for Administration

sp_msgadmin

Description

This stored procedure configures and administers messaging-related information.

Syntax

 sp_msgadmin 
 sp_msgadmin ‘help’,
 sp_msgadmin ‘help’, ‘list’ 
 sp_msgadmin ‘help’, ‘register'
 sp_msgadmin ‘help’, ‘default’
 sp_msgadmin ‘help’, ‘remove’
 sp_msgadmin 'list', 'provider' [, provider_name]
 sp_msgadmin 'list’, ’login’ [, provider_name, [login_name],
 sp_msgadmin 'list', 'subscription' [, subscription_name]
 sp_msgadmin 'register', 'provider', provider_name, provider_class,
         messaging_provider_URL
 sp_msgadmin 'register', 'login', provider_name, local_login,
        provider_login, provider_password [, role_name]
 sp_msgadmin 'register’, 'subscription', subscription_name, endpoint
       [, selector [, delivery_option [, durable_name, client_id]]]
 sp_msgadmin 'default’, 'login', provider_name, provider_login,
       provider_password
 sp_msgadmin 'remove', ’provider', provider_name
 sp_msgadmin 'remove', 'login', provider_name, local_login [, role]
 sp_msgadmin 'remove', 'subscription', subscription_name

Examples

Example 1

sp_msgadmin ’register’,’provider’,’one_jms_provider’,
     ’TIBCO_JMS’,’tcp://my_jms_host:7222’

sp_msgadmin ’default’, ’login’, ’one_jms_provider’, ’loginsa’,
     ’abcdef123456’

Usage

sp_msgadmin cannot be used inside a transaction.

Permissions

The permissions required depend on the subcommand.





Copyright © 2004. Sybase Inc. All rights reserved. sp_msgadmin 'help'

View this book as PDF