oracle user job create

create table c(a date);

create or replace procedure test1 as
begin
insert into c values(sysdate);
end;

declare
  job1 number;
begin
 dbms_job.submit(job1,'TEST1;',sysdate,'sysdate+1/1440');
end;

select * from c;
select * from user_jobs;

begin

dbms_job.run(:job1);

end;

begin
 dbms_job.remove(3);
end;

 

 

###########################################################

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'INSERT_TEST1',
job_type => 'STORED_PROCEDURE',
job_action => 'test1',
start_date => sysdate,
repeat_interval => 'FREQ=MINUTELY;INTERVAL=1');
END;

select * from user_scheduler_jobs;

begin
  dbms_scheduler.enable('INSERT_TEST1');
end;

select * from c;

begin
  dbms_scheduler.disable('INSERT_TEST1');
end;

begin
  dbms_scheduler.set_attribute('INSERT_TEST1','START_DATE',to_date('2012-12-27 15:58:00','yyyy-mm-dd hh24:mi:ss'));
  end;
 

select * from user_scheduler_job_run_details;

begin
  dbms_scheduler.set_attribute('INSERT_TEST1','LOGGING_LEVEL',DBMS_SCHEDULER.LOGGING_FULL);
end;