create or replace
procedure testjobwthpar
(id varchar2)
as
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB (
job_name => '"sample job"',
job_type => 'PLSQL_BLOCK',
job_action => 'begin TESTJOB('||id||'); end;',
number_of_arguments => 0,
start_date => TO_TIMESTAMP('03-JAN-14 09.00.00.294000000 AM', 'DD-MON-RR HH.MI.SS.FF AM'),
repeat_interval => 'FREQ=DAILY;BYHOUR=1',
end_date => NULL,
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => false,
comments => 'TEST JOB ',
credential_name => NULL,
destination_name => NULL);
END;
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at "SAMPLE", line 6
ORA-06512: at line 6
i gave the Grant permission to sys also...but still i am facing the same error pls need your help for proceed this..