×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Jan 11, 2018 2:37 PM
Views: 2
Tags: no tags
  1. BEGIN
  2. dbms_scheduler.create_job (
  3.    job_name           =>  'ETLJ_RES_RSIBCOHORTS_APPEND',
  4.    job_type           =>  'STORED_PROCEDURE',
  5.    job_action         =>  'system.load_sales',
  6.    start_date         =>  '01-MAR-2010 03:00:00 AM',
  7.    repeat_interval    =>  'FREQ=DAILY',
  8.    enabled            =>  TRUE);
  9. END;
  10. /