Neoview Workload Management Services Guide (R2.4)

STATUS SERVICE EXEC Command
The STATUS SERVICE EXEC command returns the names of the execution rules associated with
the specified service.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
STATUS SERVICE service-name EXEC
service-name
is the name of a user-defined service for managing queries. service-name can be a maximum
of 24 characters and must be a unique name in WMS. service-name must exist in the WMS
configuration but cannot be the SYSTEM service. The service name is not case-sensitive and
is always converted to uppercase. WMS supports multibyte characters in the service name.
For guidelines on using multibyte character sets, see the Neoview Character Sets Administrator's
Guide. For output information, see Table A-21 (page 143).
Considerations
• The STATUS SERVICE EXEC command returns this information:
Table A-23 STATUS SERVICE EXEC Output
DescriptionData TypeColumn Name
EXECVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)RULE_NAME
Services to which the rule is associatedVARCHAR(96)SERVICE_NAME
Examples
• This command displays the names of the execution rules associated with SERVICE1:
STATUS SERVICE SERVICE1 EXEC;
STATUS SERVICE EXEC Command 145