Rem Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/latest/admin/admin_submit_dbms_jobs.sql /st_emcore_10.2.0.4.1db11/1 2008/08/01 11:06:40 edemembe Exp $ Rem Rem admin_submit_dbms_jobs.sql Rem Rem Copyright (c) 2003, 2008, Oracle. All rights reserved. Rem Rem NAME Rem admin_submit_dbms_jobs.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem edemembe 07/30/08 - Bug 7286326 Rem rpinnama 07/03/03 - rpinnama_fix_3011993_main Rem rpinnama 07/03/03 - Created Rem Rem Rem Submitting DBMS jobs Rem PROMPT Submitting DBMS jobs. DECLARE l_database_role VARCHAR2(32); BEGIN -- Check to see if this database is in logical standby mode. If it is -- we need to exit this script because logical standby doesn't support -- DBMS_JOBS. BEGIN SELECT database_role into l_database_role from v$database where database_role like '%LOGICAL%'; EXCEPTION WHEN NO_DATA_FOUND THEN EMD_MAINTENANCE.SUBMIT_EM_DBMS_JOBS; COMMIT; END; END; /