DROP EVENT

Description

Deletes a scheduled task.

Precautions

Operations related to scheduled tasks are supported only when sql_compatibility is set to 'B'.

Syntax

DROP EVENT [IF EXISTS] event_name

Parameters

• IF EXISTS

  If the scheduled task does not exist, a NOTICE message is displayed.

Example

gaussdb=# DROP EVENT event_e1;