Required suggestion which schedular has to use
Hi,
on production, we run the stats job at 00:00 (midnight) and we want the job to run only for 6 hrs as there is application traffic and other batch jobs which kicks off at 6 AM.
We dont want the stats job to create any issue during the app traffic.By running for 6 hrs, we will ensure that the job runs during off peak hrs (during night).
We created below 2 test cases and need suggestion which schedular has to use
1st:
BEGIN
dbms_scheduler.create_window(window_name=>'MAINT1_WINDOW',
resource_plan => NULL,
schedule_name=>'STATS_WEEKDAY_RUN',
duration=>INTERVAL '6' hour,
We dont want the stats job to create any issue during the app traffic.By running for 6 hrs, we will ensure that the job runs during off peak hrs (during night).
We created below 2 test cases and need suggestion which schedular has to use
1st:
BEGIN
dbms_scheduler.create_window(window_name=>'MAINT1_WINDOW',
resource_plan => NULL,
schedule_name=>'STATS_WEEKDAY_RUN',
duration=>INTERVAL '6' hour,
0