ALTER SCHEDULER RULE
Use the ALTER SCHEDULER RULE command to rename or to change the owner of a scheduler rule.
Syntax
Syntax for changing the owner of a scheduler rule:
ALTER SCHEDULER RULE <rule_name> OWNER TO <new_owner_name>
Syntax
for renaming a scheduler rule:
ALTER SCHEDULER RULE <rule_name> RENAME TO <new_rule_name>
Inputs
The ALTER SCHEDULER RULE command
takes the following inputs:
Input | Description |
---|---|
<rule_name> | The name of the scheduler rule to be altered. |
<new_owner_name> | The name of the new owner of the scheduler rule. |
<new_rule_name> | The new scheduler rule name. |
Outputs
The ALTER SCHEDULER RULE command
has the following output:
Output | Description |
---|---|
ALTER SCHEDULER RULE | The command was successful. |
Privileges
You must be the admin user, the owner of the scheduler rule, or your account must have the Scheduler Rule privilege.
Usage
The following provides
sample usage:
- To change the owner of the scheduler rule with the name
rule1
to Karl, and to prevent the specified user ID from being converted to the default case:MYDB.MYSCH(USER)=> ALTER SCHEDULER RULE rule1 OWNER TO 'Karl'
- To change the name of the scheduler rule
rule1
togwrule
:MYDB.MYSCH(USER)=> ALTER SCHEDULER RULE rule1 RENAME TO gwrule