Rem
Rem $Header: admin_dbms_jobs.sql 31-mar-2003.09:49:34 rpinnama Exp $
Rem
Rem admin_dbms_jobs.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      admin_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    rpinnama    03/31/03 - rpinnama_setup_repos_migration_main
Rem    rpinnama    03/25/03 - Parameterize repos user
Rem    rpinnama    03/21/03 - rpinnama_setup_repos_migration
Rem    rpinnama    03/17/03 - Created
Rem

Rem 
Rem This SQL script requires the following arguments
Rem  1. Name of the repository user
Rem
DEFINE EM_REPOS_USER ="&1"


--
-- Submit job to analyze the tables once a day at 3:10am.
--
REM  Submit job to analyze the tables once a day.
BEGIN

  emd_maintenance.update_stale_stats('&EM_REPOS_USER',
                                     TO_CHAR((SYSDATE+1),'DAY'),
                                     03,
                                     10,
                                     1);
  COMMIT;
END;
/