DBA_AUTOTASK_TASK is empty
I'm trying to check out the new automatic tasks in 11gR2 and I'm having a little trouble getting them to run. I check dba_autotask_client and I see that all three default tasks are there and enabled:
SQL> SELECT client_name,status,consumer_group FROM dba_autotask_client;
CLIENT_NAME STATUS CONSUMER_GROUP
------------------------- -------- ------------------------------
auto optimizer stats coll ENABLED ORA$AUTOTASK_STATS_GROUP
ection
auto space advisor ENABLED ORA$AUTOTASK_SPACE_GROUP
sql tuning advisor ENABLED ORA$AUTOTASK_SQL_GROUP
But when I check dba_autotask_task there are no rows returned:
SQL> select client_name,status from DBA_AUTOTASK_TASK;
no rows selected
Same when I check dba_autotask_job_history:
SQL> select * from DBA_AUTOTASK_JOB_HISTORY;
no rows selected
But when I check the maintenance windows they are enabled:
select * from DBA_AUTOTASK_WINDOW_HISTORY;
WINDOW_NAME WINDOW_START_TIME WINDOW_END_TIME
------------------------- ------------------------- -------------------------
SATURDAY_WINDOW 27-AUG-11 06.00.00.329614 28-AUG-11 02.00.00.003701
AM +00:00 AM +00:00
SUNDAY_WINDOW 28-AUG-11 06.00.00.243683 29-AUG-11 02.00.00.017650
AM +00:00 AM +00:00
MONDAY_WINDOW 29-AUG-11 10.00.00.090754 30-AUG-11 03.42.02.261462
PM +00:00 PM +00:00
MONDAY_WINDOW 01-AUG-11 10.00.00.153345 02-AUG-11 02.00.00.014974
Any idea how to get them to run?