CREATE TABLE dept1 AS SELECT * FROM dept;

CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;


BEGIN
 DBMS_SCHEDULER.CREATE_PROGRAM (
    program_name        => 'all_record_program1',
    PROGRAM_TYPE        => 'STORED_PROCEDURE',
    program_action      => 'UPDATE_RECORD',
    number_of_arguments => 1,
    ENABLED             => FALSE,
    comments            => 'Program to insert records.');

  DBMS_SCHEDULER.define_program_argument (
    PROGRAM_NAME      => 'all_record_program1',
    argument_name     => 'p_deptno',
    argument_position => 1,
    ARGUMENT_TYPE     => 'NUMBER',
    default_value     => '90');
    
 DBMS_SCHEDULER.ENABLE (NAME => 'all_record_program1');

    DBMS_SCHEDULER.CREATE_SCHEDULE (
    schedule_name   => 'all_record_schedule1',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'FREQ=MINUTELY; INTERVAL=5; BYSECOND=00;',
    END_DATE        => NULL,
    comments        => 'Repeats every 5 minutes.');

 DBMS_SCHEDULER.CREATE_JOB (
    job_name      => 'all_record_job1',
    program_name  => 'all_record_program1',
    schedule_name => 'all_record_schedule1',
    ENABLED       => TRUE,
    comments      => 'Job defined to insert records into the dept table.');
END;

select value from v$parameter where name='job_queue_processes';

 alter system set job_queue_processes=1000;