Autotasks frequency question
Hello Everyone,
I have a question please:
Regarding 11g autotasks, as per the result of the following query, the optimizer stats collection ran once in each weekday window and 5 times in
weekends windows. I know I can control the duration and the time of each window but can I control the frequency of the job (for example make it run only 3 times in weekends) ?
Thanks
SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed
FROM dba_autotask_client_history
WHERE client_name like '%stats%';
2 3
CLIENT_NAME WINDOW_NAME JOBS_CREATED JOBS_STARTED JOBS_COMPLETED
---------------------------------------- ----------------------------------------------------------------- ------------ ------------ --------------
I have a question please:
Regarding 11g autotasks, as per the result of the following query, the optimizer stats collection ran once in each weekday window and 5 times in
weekends windows. I know I can control the duration and the time of each window but can I control the frequency of the job (for example make it run only 3 times in weekends) ?
Thanks
SELECT client_name, window_name, jobs_created, jobs_started, jobs_completed
FROM dba_autotask_client_history
WHERE client_name like '%stats%';
2 3
CLIENT_NAME WINDOW_NAME JOBS_CREATED JOBS_STARTED JOBS_COMPLETED
---------------------------------------- ----------------------------------------------------------------- ------------ ------------ --------------
0