Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\db\latest\eval\eval_dbms_jobs.sql
Rem Rem $Header: eval_dbms_jobs.sql 10-jul-2003.17:36:53 yfeng Exp $ Rem Rem eval_dbms_jobs.sql Rem Rem Copyright (c) 2003, Oracle Corporation. All rights reserved. Rem Rem NAME Rem eval_dbms_jobs.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 yfeng 07/10/03 - Remove the job for bad sql evaluation Rem rpinnama 03/31/03 - rpinnama_setup_repos_migration_main Rem rpinnama 03/17/03 - Created Rem -- -- Submit the SQL evaluation process to run every 6 hours -- -- VARIABLE v_JobNum NUMBER -- BEGIN -- DBMS_JOB.SUBMIT(:v_JobNum, -- 'EMD_EVALUATION.EVALSQLMETRICS();', -- SYSDATE, 'sysdate + (6/24)' ); -- COMMIT; -- END; -- /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de