|
Code Listing 2: Creating a schedule
BEGIN
sys.dbms_scheduler.create_schedule(
repeat_interval =>
'FREQ=DAILY;INTERVAL=2;BYHOUR=18;BYMINUTE=0;BYSECOND=0',
start_date =>
to_timestamp_tz('2004-03-22 US/Eastern', 'YYYY-MM-DD TZR'),
comments =>
'Schedule for periodic loads of customer-related data',
schedule_name => '"GENNICK"."PERIODICLOADS"');
END;
|