What should the repeat interval of the schedule be set to create a schedule that will run a job on the second Friday of each month?

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?

A.
FREQ = MONTHLY; BYDAY = 2FRI;

B.
FREQ = MONTHLY; BYDAY = FRI2;

C.
FREQ = MONTHLY; BYDAY = 2FRI;

D.
FREQ = MONTHLY; BYDAY = FRI(2);

Explanation:
Examples of Calendaring Expressions
The following examples illustrate simple repeat intervals. For simplicity, it is assumed that there is no contribution to the evaluation results by the start date.

Run every Friday. (All three examples are equivalent.)
FREQ = daily; BYDAY = FRI;
FREQ = weekly; BYDAY =FRI;
FREQ = yearly; BYDAY =FRI;

Run on the second Wednesday of each month.
FREQ = monthly; BYDAY =2wed;

REF: Oracle(r) 10g Administrator Guide , 27-14



Leave a Reply 1

Your email address will not be published. Required fields are marked *


mr_tienvu

mr_tienvu

I have the same idea.