SCHEDULE 简单测试

create table temp_test_schedule
(
createdate date,
num number
);


begin
 dbms_scheduler.create_schedule(schedule_name   => 'TEST_SCHEDULE',
                                start_date      =>sysdate ,
                                repeat_interval => 'FREQ=MINUTELY;INTERVAL=1',
                                end_date        => null,
                                comments        => null);
/*dbms_scheduler.drop_schedule( 'TEST_SCHEDULE');*/
end;
/


select * from user_scheduler_schedules;


begin
 dbms_scheduler.create_program(program_name        => 'PRO_TEST_SCHEDULE',
                               program_type        => 'STORED_PROCEDURE',
                               program_action      => 'PROC_TEST_SCHEDULE',
                               number_of_arguments => 0,
                               enabled             => true,
                               comments            => null);
end;
/


select * from user_scheduler_programs;




begin
 dbms_scheduler.create_job(  job_name=> 'JOB_TEST_SCHEDULE',
  program_name => 'PRO_TEST_SCHEDULE',
  schedule_name =>'TEST_SCHEDULE',
  enabled => true
  );
 /* dbms_scheduler.enable('JOB_TEST_SCHEDULE');*/
/*  dbms_scheduler.run_job('JOB_TEST_SCHEDULE');*/
/*  dbms_scheduler.drop_job(job_name => 'JOB_TEST_SCHEDULE');*/
end;
/
select * from user_scheduler_jobs;
select * from user_scheduler_job_run_details;