The CANCEL PROJECT statement will terminate a running project, i.e. find the session and cancel its statement. This requires the CANCEL SESSION privilege.

Syntax

CANCEL PROJECT { '<project_name>' | ID '<id>' }

Arguments

  • ‘project_name’ - user specified project name added during CREATE or ALTER PROJECT command. These are unique for all active projects, but not for deactivated projects.

  • ‘id’ - Cirro assigned project ID. Once a project has been created it can be referenced by ID (alter, execute, drop).

Additional Information

  • EXECUTE PROJECT and DROP PROJECT should fail with an error if the project is currently executing.

Examples

CANCEL PROJECT { project_name | ID identifier }

Like CANCEL SESSION, stop a currently running project.

CANCEL PROJECT ID 665 ;

See Also