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>

The ALTER SCHEDULER RULE command takes the following inputs:

Table 1. ALTER SCHEDULER RULE 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.

The ALTER SCHEDULER RULE command has the following output:

Table 2. ALTER SCHEDULER RULE output
Output	Description
`ALTER SCHEDULER RULE`	The command was successful.

You must be the admin user, the owner of the scheduler rule, or your account must have the Scheduler Rule privilege.

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 to gwrule:

MYDB.MYSCH(USER)=> ALTER SCHEDULER RULE rule1 RENAME TO gwrule