Oracle Error ORA-27411: empty string is not a valid repeat interval.

Oracle Error Message

ORA-27411: empty string is not a valid repeat interval.

Reason for the Error

An empty string ” was provided as a repeat interval for a window or a schedule.

Solution

Specify a valid repeat interval, e.g., ‘FREQ=DAILY;BYHOUR=8;BYMINUTE=0;BYSECOND=0’ for a job that executes daily at 8am.