DROP SCHEDULER RULE

Use the DROP SCHEDULER RULE command to delete a scheduler rule from the system.

Syntax

Syntax for dropping a scheduler rule:
DROP SCHEDULER RULE <rule_name>

Input

The DROP SCHEDULER RULE command takes the following input:
Table 1. DROP SCHEDULER RULE input
Input Description
rule_name The name of the scheduler rule to be dropped.

Outputs

The DROP SCHEDULER RULE command has the following outputs:

Table 2. DROP SCHEDULER RULE outputs
Output Description
DROP SCHEDULER RULE The command was successful.
ERROR: permission denied You do not have the necessary permission to issue this command.

Privileges

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

Usage

The following provides sample usage.
  • To drop the scheduler rule with the name rule1: 
    MYDB.MYSCH(USER)=> DROP SCHEDULER RULE rule1;