2 Replies Latest reply: Mar 28, 2014 5:10 AM by user545194 RSS

    Scheduler for analyzing tables and other tasks

    user545194

      Hi,

       

      DB: 11gR2 on Windows Server 2008R2

       

      1. Is there an example of how to enable (set up) the Scheduler for maintenance jobs, i.e. analyzing tables and checking these

      tasks/settings:

       

      /*

      Checking if "auto optimizer stats collection" is there and enabled

      */

      select * from DBA_AUTOTASK_OPERATION;

      */

      select * from DBA_AUTOTASK_SCHEDULE;

      /*

      Checking which window group it is in

      */

      select * from DBA_AUTOTASK_CLIENT;

      /*

      Checking which windows are part of this window group

      */

      select * from dba_scheduler_wingroup_members;

      /*

      Checking if the windows in the group are enabled

      */

      SELECT * FROM dba_scheduler_windows;

       

      2. Can the Scheduler be set up via SQL Developer?

       

      Thanks for your feedback!