SET SCHEDULER RULE

Use the SET SCHEDULER RULE command to deactivate or reactivate a scheduler rule.

Syntax

Syntax for setting a scheduler rule:

SET SCHEDULER RULE <rule_name> { OFF | ON }

The SET SCHEDULER RULE command takes the following inputs:

Table 1. SET SCHEDULER RULE inputs
Input	Description
<rule_name>	The name of the scheduler rule to be deactivated (OFF) or reactivated (ON).

The SET SCHEDULER RULE command has the following outputs:

Table 2. SET SCHEDULER RULE outputs
Output	Description
`SET SCHEDULER RULE`	The command was successful.
`ERROR: Read-only session, cannot process this request`	The command was issued during a read-only session.

You must be the admin user or you must be granted the SCHEDULER RULE privilege.

The following provides sample usage.

To deactivate the scheduler rule with the name rule1:
```
MYDB.MYSCH(USER)=> SET SCHEDULER RULE rule1 OFF;
```