Neoview Workload Management Services Guide (R2.5)

ALTER SERVICE EXEC Command
The ALTER SERVICE EXEC command associates execution rules with a service.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ALTER SERVICE service-name EXEC rule-list
rule-list is:
( [ rule-name [ , rule-name ... ] | RESET ] )
service-name
is the name of an existing service for managing queries. service-name must exist in the
WMS configuration and cannot be the SYSTEM service.
rule-name
is the name of an existing execution rule. The order of the rules in the rule-list is the
order in which WMS evaluates the rules.
RESET
removes the association between the user-defined execution rules and the service.
Considerations
• Specifying empty parentheses removes the association between the user-defined execution
rules and the service and has same effect as the RESET option:
alter service service1 exec ( );
• You can assign a maximum of 100 rules to a service.
• You cannot have more then 988 rule-to-service associations.
Example
This command associates the execution rules, EXECRULE1, EXECRULE2, and EXECRULE3,
with SERVICE1:
ALTER SERVICE SERVICE1 EXEC (EXECRULE1, EXECRULE2, EXECRULE3);
ALTER SERVICE EXEC Command 203