SHOW SCHEDULER RULE

Use the SHOW SCHEDULER RULE command to display a list of all the scheduler rules for the current session.

Syntax

Syntax for the SHOW SCHEDULER RULE command:
SHOW SCHEDULER RULE [ALL | <string>] [VERBOSE]

Inputs

The SHOW SCHEDULER RULE command takes the following inputs:

Table 1. SHOW SCHEDULER RULE inputs
Input Description
ALL Display a list of all the scheduler rules that you are authorized to display. This is the default.
<string> Display a list of all the scheduler rules that you are authorized to display and that have names that begin with the specified string.
VERBOSE In addition to the name and contents of each scheduler rule, display:
  • Whether the rule is active (t=true, f=false)
  • The name of the owner of the rule
  • Whether the rule applies to Admin jobs (t=true, f=false)

Privileges

If you are the admin user or if you have the Scheduler Rules privilege, you can display a list of all the scheduler rules; otherwise you can display information about only the scheduler rules that you own.

Usage

  • The following command shows information about all scheduler rules:
    MYDB.MYSCH(USER)=> SHOW SCHEDULER RULE;
SCHEDULER RULE
    NAME     |                   RULE                  
-------------+-----------------------------------------
R1_RSG1_MAX2 | IF RESOURCEGROUP IS RSG1 THEN LIMIT 2   
R2_SQB       | IF TAG IS "short query" THEN SET SHORT
  • The following command shows additional information about all scheduler rules:
    MYDB.MYSCH(USER)=> SHOW SCHEDULER RULE VERBOSE;
SCHEDULER RULE
    NAME     |                   RULE                 | ACTIVE | OWNER | ADMIN
-------------+----------------------------------------+--------+-------+------
R1_RSG1_MAX2 | IF RESOURCEGROUP IS RSG1 THEN LIMIT 2  | t      | ADMIN | f
R2_SQB       | IF TAG IS "short query" THEN SET SHORT | f      | ADMIN | t
  • The following command shows additional information about all scheduler rules that begin with the string R1_R:
    MYDB.MYSCH(USER)=> SHOW SCHEDULER RULE R1_R;
SCHEDULER RULE
    NAME     |                   RULE                  
-------------+-----------------------------------------
R1_RSG1_MAX2 | IF RESOURCEGROUP IS RSG1 THEN LIMIT 2