title: Cannot get auto optimizer stats collection job to run after Oracle 11g upgrade
body: <p>We recently upgraded our 10g server to 11g (11.2.0.3.0), and I see that stats gathering should be handled via the Automated Maintenance Tasks feature - specifically the "auto optimizer stats collection" job.</p>
  
  <p>However, since our upgrade (5 days ago), I have not seen any of these jobs run in the scheduler, and the Automated Maintenance Tasks interface in OEM does not show the jobs having been run.  DBA_AUTOTASK_JOB_HISTORY has no rows, and I see no history of any stat job running in the scheduler tab or OEM, yet as far as I can tell, the system is configured correctly:</p>
  
  <pre><code>    SELECT col
           , val
        FROM ( SELECT *
                 FROM DBA_AUTOTASK_CLIENT
                WHERE CLIENT_NAME = 'auto optimizer stats collection'
             )
     UNPIVOT (    val                            
              FOR col                              
               IN ( CLIENT_NAME
                  , STATUS
                  , CONSUMER_GROUP
                  , CLIENT_TAG
                  , PRIORITY_OVERRIDE
                  , ATTRIBUTES
                  , WINDOW_GROUP
                  , SERVICE_NAME
                  )
             );
  
    COL               VAL
    ----------------- ---------------------------------------
    CLIENT_NAME       auto optimizer stats collection
    STATUS            ENABLED
    CONSUMER_GROUP    ORA$AUTOTASK_STATS_GROUP
    CLIENT_TAG        OS
    PRIORITY_OVERRIDE INVALID
    ATTRIBUTES        ON BY DEFAULT, VOLATILE, SAFE TO KILL
    WINDOW_GROUP      ORA$AT_WGRP_OS
  
  
    SQL&gt; select * from DBA_AUTOTASK_WINDOW_CLIENTS;
  
    WINDOW_NAME                    WINDOW_NEXT_TIME                                                            WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M
    ------------------------------ --------------------------------------------------------------------------- ----- -------- -------- -------- -------- --------
    MONDAY_WINDOW                  01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    TUESDAY_WINDOW                 01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    WEDNESDAY_WINDOW               01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    THURSDAY_WINDOW                01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    FRIDAY_WINDOW                  01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    SATURDAY_WINDOW                01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
    SUNDAY_WINDOW                  01-NOV-12 10.00.00.000000 AM AMERICA/NEW_YORK                               FALSE ENABLED  ENABLED  DISABLED ENABLED  DISABLED
  </code></pre>
  
  <p>Have I missed something?</p>