rem
rem This script can be used to deactivate all incomplete deployment and execution jobs.
rem
rem USAGE
rem Logon as WorkspaceOwner or WorkspaceUser with Admin privilege
rem    
rem    @<OWB-HOME>/owb/rtp/sql/deactivate_all.sql <workspace>
rem
rem The given workspace is the one in which the jobs are 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('&1.');

declare
begin
  owbsys.wb_rt_script_util.deactivate_all();  

end;
/