Managing the Rules of the Resource Manager¶
This section shows the syntax of the commands to create, modify and delete rules of the resource manager.
Syntax of the CREATE RESOURCE_MANAGER RULE statement¶
CREATE [ OR REPLACE ] RESOURCE_MANAGER RULE <name:identifier>
[ DESCRIPTION = <description:literal> ]
CONDITION <condition>
RESOURCE_MANAGER PLAN <name:identifier>
<condition> ::= (see Rules for forming functions)
<identifier> ::= (see Basic primitives for specifying VQL statements)
Syntax of the ALTER RESOURCE_MANAGER RULE statement¶
ALTER RESOURCE_MANAGER RULE <name:identifier>
[ RENAME <new_name:identifier> ]
[ DESCRIPTION = <description:literal> ]
[ CONDITION <condition> ]
[ RESOURCE_MANAGER PLAN <name:identifier> ]
To list the existing rules, run LIST RESOURCE_MANAGER RULES
.
To drop a plan, execute DROP RESOURCE_MANAGER RULE
:
Syntax of the DROP RESOURCE_MANAGER RULE statement¶
DROP RESOURCE_MANAGER RULE [ IF EXISTS ] <name:identifier>