Hello
How do I verify stats job is running on 12.1.0.2.0 ?
I can see it is enabled
SQL> select CLIENT_NAME,status from dba_autotask_client where client_name like '%auto optimizer stats collection%';
CLIENT_NAME STATUS
-------------------------------- --------
auto optimizer stats collection ENABLED
however, I can't see anything in the history
SQL> SELECT window_name, jobs_created, jobs_started, jobs_completed, WINDOW_START_TIME , WINDOW_END_TIME
FROM dba_autotask_client_history
WHERE client_name like '%auto optimizer stats collection%';
no rows selected