-- create job

BEGIN
DBMS_SCHEDULER.create_program(
program_name => 'akn_prog1',
program_type => 'EXECUTABLE',
program_action => '/oracle/koccrmett/tani/tani_tekil_id_degisen.sh',
number_of_arguments => 0,
enabled => TRUE,
comments => 'Test Program sh tekil'
);
END;

--create job

BEGIN
DBMS_SCHEDULER.create_job(job_name => 'akn_job1',
program_name => 'akn_prog1',
start_date => NULL,
repeat_interval => NULL,
end_date => NULL,
enabled => TRUE,
auto_drop => FALSE,
comments => 'Export data Job');
END;

-- enable program and job

BEGIN
DBMS_SCHEDULER.enable(NAME => 'akn_job1');
DBMS_SCHEDULER.enable(NAME => 'akn_prog1');
END;
/

-- run job

BEGIN
DBMS_SCHEDULER.RUN_JOB(job_name => 'akn_job1',use_current_session => TRUE);
END;