Dear Friends
I am working on Oracle 10g Database. I created a procedure to insert the data in the table calling through a job but its not working. When i check the property/view of job through PL/SQL Developer. it gives the below error.
My procedure is
create or replace procedure testjob is
begin
insert into test
(emp_id,emp_name)
values
(1,'kkk');
commit;
end testjob;
and job is as below
BEGIN
dbms_scheduler.create_job (
job_name => 'MYJOB',
job_type => 'PLSQL_BLOCK',
job_action => 'TESTJOB;',
start_date => '10/sep/2020 9.15.00AM',
enabled => true,
repeat_interval => 'FREQ=DAILY;INTERVAL=1'
);
END;
Please help.
Regards
Kam