Rem
Rem $Header: jobs_recovery_pkgdef.sql 13-sep-2007.01:29:20 shnavane Exp $
Rem
Rem jobs_recovery_pkgdef.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      jobs_recovery_pkgdef.sql - utility recovery routines
Rem
Rem    DESCRIPTION
Rem      utility recovery routines
Rem
Rem    NOTES
Rem      These routines should not be called directly
Rem      They are for recovery situations or upgrade cases
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    shnavane    09/18/07 - Backport shnavane_bug-6391386 from main
Rem    rdabbott    08/23/07 - delete_orphans -> delete_orphan_schedules
Rem    rdabbott    08/22/07 - prefix EM_ instead of MGMT_
Rem    rdabbott    08/17/07 - fix 6327699: utility recovery routines
Rem    rdabbott    08/17/07 - Created
Rem

--------------------------------------------
CREATE OR REPLACE PACKAGE EM_JOB_RECOVERY AS
--------------------------------------------

PROCEDURE delete_orphan_schedules;

PROCEDURE delete_orphan_large_params;

PROCEDURE add_missing_large_params; 

PROCEDURE fix_large_params_ref_count;

-- submit_dbms_job('EM_JOB_RECOVERY.delete_orphan_schedules;', SYSDATE+1);
PROCEDURE submit_dbms_job ( p_what        VARCHAR2,
                            p_start_date  DATE     DEFAULT SYSDATE,
                            p_interval    VARCHAR2 DEFAULT NULL );


END EM_JOB_RECOVERY;
/
show errors;