Rem drv: <create type="triggers" pos="-"/>
Rem
Rem $Header: availability_triggers.sql 01-jul-2005.22:01:27 gsbhatia Exp $
Rem
Rem availability_triggers.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      availability_triggers.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    gsbhatia    07/01/05 - New repmgr header impl 
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    gsbhatia    02/13/05 - updating repmgr header 
Rem    gsbhatia    02/09/05 - updating repmgr header 
Rem    gsbhatia    02/07/05 - updating repmgr header 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    streddy     04/24/03 - Handle master agent changes
Rem    rpinnama    05/14/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/14/02 - Created
Rem

rem
rem  Trigger to close the previous master agent record for a target.
rem
CREATE OR REPLACE TRIGGER master_agent_change_trigger
   BEFORE INSERT ON MGMT_MASTER_AGENT FOR EACH ROW
BEGIN
     em_master_agent.process_new_master_agent(:new.target_guid,
                                              :new.agent_guid,
                                              :new.start_timestamp);
END;

/
show errors;