SET SCHEDULER RULE
Use the SET SCHEDULER RULE command to deactivate or reactivate a scheduler rule.
Syntax
Inputs
The SET SCHEDULER RULE command takes
the following inputs:
Input | Description |
---|---|
<rule_name> | The name of the scheduler rule to be deactivated (OFF) or reactivated (ON). |
Outputs
The SET SCHEDULER RULE command has
the following 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. |
Privileges
You must be the admin user or you must be granted the SCHEDULER RULE privilege.
Usage
The following provides sample usage.
- To deactivate the scheduler rule with the name
rule1
:MYDB.MYSCH(USER)=> SET SCHEDULER RULE rule1 OFF;