rem
rem This script can be used to deactivate an execution job.
rem
rem USAGE
rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege
rem    
rem    @<OWB-HOME>/owb/rtp/sql/deactivate_execution.sql <auditid> <workspace>
rem
rem For a given audit-id which represents an execution job, this script will
rem deactivate it so that the job is Completed in a managed way. The audit-id
rem may have been obtained by using the list_requests.sql script.
rem
rem The given workspace is the one in which the job is running
rem <workspace> should be declared as workspaceOwner.workspaceName
rem if only workspaceName is given, workspaceOwner will be defaulted to user
rem

set verify off;

set role OWB_USER;
call owbsys.wb_rt_script_util.set_workspace('&2.');

declare
begin
  owbsys.wb_rt_script_util.deactivate_execution(&1.);
  
end;
/