Database Administration (MOSC)

MOSC Banner

Autotask jobs run only on weekends, but are scheduled for every day

edited Nov 14, 2019 2:47AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hello I all,

I want to run the autotask Jobs (in a 11.2.03 . database )  during every maintenance window , but they start only during weekends. Consider :

SQL> SELECT

  2   CLIENT_NAME, WINDOW_NAME, JOBS_CREATED, JOBS_STARTED, JOBS_COMPLETED

  3  FROM

  4      dba_autotask_client_history;

CLIENT_NAME                         WINDOW_NAME          JOBS_CREATED JOBS_STARTED JOBS_COMPLETED

----------------------------------- -------------------- ------------ ------------ --------------

auto optimizer stats collection     SATURDAY_WINDOW                 5            5              5

auto optimizer stats collection     SATURDAY_WINDOW                 5            5              5

auto optimizer stats collection     SUNDAY_WINDOW                   1            1              1

auto optimizer stats collection     SUNDAY_WINDOW                   1            1              1

auto optimizer stats collection     SUNDAY_WINDOW                   1            1              1

auto optimizer stats collection     SUNDAY_WINDOW                   1            1              1

auto optimizer stats collection     SUNDAY_WINDOW                   1            1              1

auto space advisor                  SATURDAY_WINDOW                 5            5              5

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center