You work as a Database Administrator for Veedol Inc. Your manager wants you to run a job that updates the transaction table every 30 minutes. To schedule the job, you have to set the value of the interval element. Which of the following setting for the repeat_interval argument will archive the desired objective. Each correct answer represents a complete solution.(Choose two.)
A. 'freq=hourly; interval=1/2'
B. 'freq=hourly; byminute=30'
C. '0 00:30:00'
D. 'freq=minutely; interval=30'
E. 'freq=minutely; byminute=30'
F. 'freq=minutely; interval='30'minutes'
Answer: D
SQL> alter session set nls_timestamp_tz_format='MM-DD-YYYY HH24:MI:SS tzr tzd';
会话已更改。
SQL> set serveroutput on;
SQL> declare
2 procedure list_next_run_dates(
3 start_date_i in timestamp with time zone,
4 calendar_string_i in varchar2,
5 date_count_i in integer default 8)
6 is
7 i_return_date_after timestamp with time zone;
8 i_next_run_date timestamp with time zone;
9 begin
10 i_return_date_after :=start_date_i;
11 for i in 1 .. date_count_i
12 loop
13 dbms_scheduler.evaluate_calendar_string(
14 calendar_string => calendar_string_i,
15 start_date => start_date_i,
16 return_date_after => i_return_date_after,
17 next_run_date => i_next_run_date);
18 dbms_output.put_line(i_next_run_date);
19 i_return_date_after := i_next_run_date;
20 end loop;
21 exception
22 when others then
23 dbms_output.put_line('ERROR');
24 end;
25 begin
26 dbms_output.put_line('FREQ=HOURLY; BYMINUTE=30');
27 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=HOURLY; BYMINUTE=30');
28 dbms_output.put_line('FREQ=HOURLY; interval=30');
29 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; interval=30');
30 dbms_output.put_line('FREQ=MINUTELY; BYMINUTE=30');
31 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; BYMINUTE=30');
32 dbms_output.put_line('FREQ=MINUTELY; interval=30 minutes');
33 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=MINUTELY; interval=30 minutes');
34 dbms_output.put_line('FREQ=HOURLY; interval=1/2');
35 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'FREQ=HOURLY; interval=1/2');
36 dbms_output.put_line('0 00;30:00');
37 list_next_run_dates(to_timestamp_tz(trunc(sysdate)+10/24),'0 00;30:00');
38 end;
39 /
FREQ=HOURLY; BYMINUTE=30
09-23-2016 10:30:00 +08:00
09-23-2016 11:30:00 +08:00
09-23-2016 12:30:00 +08:00
09-23-2016 13:30:00 +08:00
09-23-2016 14:30:00 +08:00
09-23-2016 15:30:00 +08:00
09-23-2016 16:30:00 +08:00
09-23-2016 17:30:00 +08:00
FREQ=HOURLY; interval=30
09-23-2016 10:30:00 +08:00
09-23-2016 11:00:00 +08:00
09-23-2016 11:30:00 +08:00
09-23-2016 12:00:00 +08:00
09-23-2016 12:30:00 +08:00
09-23-2016 13:00:00 +08:00
09-23-2016 13:30:00 +08:00
09-23-2016 14:00:00 +08:00
FREQ=MINUTELY; BYMINUTE=30
09-23-2016 10:30:00 +08:00
09-23-2016 11:30:00 +08:00
09-23-2016 12:30:00 +08:00
09-23-2016 13:30:00 +08:00
09-23-2016 14:30:00 +08:00
09-23-2016 15:30:00 +08:00
09-23-2016 16:30:00 +08:00
09-23-2016 17:30:00 +08:00
FREQ=MINUTELY; interval=30 minutes
ERROR
FREQ=HOURLY; interval=1/2
ERROR
0 00;30:00
ERROR来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2125383/ ，如需转载，请注明出处，否则将追究法律责任。
