|
Code Listing 3: Creating a job
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"GENNICK"."LOADNEWCUSTOMERS"',
program_name => 'GENNICK.LOADCUSTOMERS',
schedule_name => 'GENNICK.PERIODICLOADS',
job_class => 'DEFAULT_JOB_CLASS',
comments => 'Load New Customers',
auto_drop => FALSE,
enabled => TRUE);
END;
|