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;
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy