begin
dbms_scheduler.create_job(
job_name => 'job1',
job_type => 'PLSQL_BLOCK',
job_action => 'Insert into tab2 values(70,''TR'');',
start_date => sysdate,
repeat_interval => 'FREQ = DAILY; INTERVAL = 1');
end;

ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2

grant manage scheduler to scott;

-- You must commit when you are finished to add the line to sys.job$/dba_jobs
-- You must run this as sys to get the jobs to run as sys to get the correct path to run the job

variable jobno number;
variable instno number;
begin
  select max(job)+1 into :jobno from dba_jobs;
  select instance_number into :instno from v$instance;
  dbms_job.submit(:jobno,
'
begin
insert into polls.votes_audit 
select trunc(sysdate-1) create_date,OPTION_ID,HIT_COUNT 
from POLLS.VOTES 
where option_id like ''622592%'';
end;
',
trunc(sysdate)+1+1/24/60, 'trunc(sysdate)+1+1/24/60',
 TRUE, :instno);
end;
/
commit;