Rem drv: <create type="post_creation" pos="ping/ping_post_creation.sql-"/>
Rem
Rem $Header: notification_post_creation.sql 03-jul-2007.03:13:00 tsubrama Exp $
Rem
Rem notification_post_creation.sql
Rem
Rem Copyright (c) 2002, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      notification_post_creation.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    tsubrama    07/03/07 - fix for 6067675
Rem    neearora    05/15/07 - added support for repeat notifications
Rem    dcawley     07/14/05 - Call additional upgrade script 
Rem    scgrover    07/07/05 - add extended sql trace 
Rem    gsbhatia    07/03/05 - New repmgr header impl 
Rem    rpinnama    05/12/05 - Move v102010 init to v102010/notification_init 
Rem    dcawley     02/17/05 - Add target delete exceptions 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    dcawley     01/11/05 - Rename callback 
Rem    dcawley     01/06/05 - Add target deletion callback 
Rem    dcawley     12/20/04 - Add handler for rca complete 
Rem    dcawley     09/27/04 - Add CA format handler 
Rem    dcawley     09/16/04 - Define handler for policy violations 
Rem    dcawley     07/21/04 - Remove extra job 
Rem    dcawley     07/16/04 - Change handler value 
Rem    dcawley     07/09/04 - Add job format handler 
Rem    dcawley     06/30/04 - remove some format handlers 
Rem    dcawley     06/18/04 - Add new module for jobs 
Rem    rpinnama    07/25/03 - Move queue initialization to post_creation
Rem    dcawley     06/04/03 - Register callback with failover 
Rem    rpinnama    03/17/03 - Move dbms job submissions to notification_dbms_jobs file
Rem    rpinnama    10/15/02 - Fix register_logging_module API
Rem    rpinnama    10/14/02 - Use log registration API
Rem    tjaiswal    09/10/02 - Add default notification rules
Rem    aholser     05/31/02 - add displayname, dbms job info
Rem    rpinnama    05/16/02 - submit dbms_jobs to check and deliver notifications.
Rem    rpinnama    05/15/02 - rpinnama_reorg_rep_scripts
Rem    rpinnama    05/15/02 - Created
Rem

--
-- Insert the module name for performance and error logging
-- 
BEGIN
  mgmt_log.register_logging_module (EMD_NOTIFICATION.CHECK_MODULE_NAME,
				    'Notification Check',
				    'EMD_NOTIFICATION.CHECK_FOR_SEVERITIES()');

  mgmt_log.register_logging_module (EMD_NOTIFICATION.DELIVER_MODULE_NAME,
				    'Notification Delivery');

  COMMIT;

END;
/

-- Register the OMS failover callback and target deletion callback
BEGIN
  MGMT_FAILOVER.REGISTER_CALLBACK('EMD_NOTIFICATION.OMS_FAILOVER');
  COMMIT;
END;
/

-- Initialize notification queues.
BEGIN
  EMD_NOTIFICATION.INITIALIZE_QUEUES();
  COMMIT;
END;
/


-- Perform v102010 notif init
@@&&EM_SQL_ROOT/core/v102010/notification_init.sql
@@&&EM_SQL_ROOT/core/v102020/notification_init.sql
@@&&EM_SQL_ROOT/core/10.2.0.4/notification/notification_data_upgrade.sql