Rem
Rem $Header: delasrjobs.sql 17-jul-00.11:56:13 gshashik Exp $
Rem
Rem delasrjobs.sql
Rem
Rem  Copyright (c) Oracle Corporation 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      delasrjobs.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    gshashik    07/17/00 - Script to delete jobs on other master sites which
Rem    gshashik    07/17/00 - Created
Rem
connect repadmin/repadmin
set term off
set head off
set echo off
set lines 500
set feedback off
set verify off
spool deljobs.sql

SELECT 'connect repadmin/repadmin@' || dblink || ';' ||'
' || 'execute dbms_defer_sys.unschedule_push(' || ''''||global_name||''''||');'
FROM dba_repschema A ,global_name B
WHERE A.dblink != B.global_name;

spool off

@deljobs.sql
exit;