Scheduler rules tasks

You create a scheduler rule by issuing the CREATE SCHEDULER RULE nzsql command.

After you create a scheduler rule, it is active. You can temporarily deactivate an active scheduler rule, or reactivate a deactivated scheduler rule, by issuing the SET nzsql command.

To display a list of all scheduler rules, issue the SHOW SCHEDULER RULE nzsql command.

To rename a scheduler rule or to change the owner of a scheduler rule, issue the ALTER SCHEDULER RULE nzsql command.

To delete a scheduler rule, issue the DROP SCHEDULER RULE nzsql command.

Other tasks that affect scheduler rules are:
  • Adding a tag to a session using the ALTER SESSION command
  • Showing the tags for the current session using the SHOW TAGS command
  • Setting values for client information for a session using the SET command

When you drop a database or resource group that is defined in a schedule rule, the system also drops the rule. If a scheduler rule references a resource group that is altered to remove its resource settings, the scheduler rule is dropped.

The SQL commands are described in the IBM® Netezza® Database User’s Guide