sp_msgadmin 'list'

Description

Lists information for message provider, logins, or subscriptions. If you specify the provider_name, login_name, or subscription_name, information is listed for that particular provider, login, or subscription. Otherwise, information is listed for all of them.

Syntax

 sp_msgadmin ’list’, ’provider’ [, provider_name]
 sp_msgadmin ’list’ , login’, [, provider_name [, login_name]]
 sp_msgadmin ’list’ , ‘subscription’ [, subscription_name]

Parameters

‘provider’

Lists information about a particular messaging provider or about all message providers.

‘login’

Lists information about a particular messaging provider login mapping or about all messaging provider logins.

‘subscription’

Lists information about a particular subscription or about all subscriptions.

provider_name

An alias referring to the message provider, which can be as many as 30 characters in length.

login_name

A login name.

subscription_name

A subscription name.

Examples

Example 1

Lists the details for the “my_jms_provider” message provider:

sp_msgadmin ’list’, ’provider’, ’my_jms_provider’

Example 2

Lists the details for the user with a login of “loginsa”:

sp_msgadmin ’list’, ’login’, ’my_jms_provider’,’loginsa’

Example 3

Lists the details for subscription “subscription_1”.

sp_msgadmin ’list’, ’subscription’,’subscription_1’

Usage

See the Usage section under sp_msgadmin.

Permissions

No special permissions are required.

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF