Execute/run the specified data project. EXECUTE PROJECT executes in the current session synchronously.

Syntax

EXECUTE PROJECT { project_name | ID identifier } [DETACH]

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).

  • DETACH - This would execute asynchronously with the details of the initiation session.

Additional Information

  • System first checks that the current session has execute permission on the project.

  • The script for the given project is executed in the current session, but the effective user is changed to the project’s run-as user.

  • All run logging must be performed.

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

Examples

Run the contents of the project, i.e. scripts, in the current session.

EXECUTE PROJECT ID 665 ;

Run the project but do not block the current session.

EXECUTE PROJECT ID 665 DETACH ;

See Also