How to call a stored procedure in an Oracle Scheduler job I want to call a stored procedure in an Oracle Scheduler job. My procedure and job are shown below:

Stored procedure

create or replace PROCEDURE emp_test                                              
IS
begin

delete from  emp;
insert into emp(empid,empname)
select empid1,empname1 from emp_temp;
end;


Job

BEGIN
dbms_scheduler.create_job (
job_name =&gt; 'emp_test_JOB',
job_type =&gt; 'PLSQL_BLOCK',
job_action =&gt; 'BEGIN
CALL emp_test();
END;',
start_date =&gt; SYSTIMESTAMP,
enabled =&gt; true,
repeat_interval =&gt; 'FREQ=DAILY');
END;


I am able to call procedure like CALL emp_test() with out using a job.

When I am using same thing in a job like above, the job was created successfully but the procedure is not running, rows are not inserted. I need run this job and rows should be inserted; can any one help me please?
You don't need CALL when creating a job (and parenthesis for a procedure that takes no arguments ).  I'd also specify  INTERVAL=1 explicitly. 

BEGIN 
   dbms_scheduler.create_job ( 
    job_name =&gt; 'emp_test_JOB', 
    job_type =&gt; 'PLSQL_BLOCK', 
    job_action =&gt; 'emp_test;', 
    start_date =&gt; SYSTIMESTAMP, 
    enabled =&gt; true, 
    repeat_interval =&gt; 'FREQ=DAILY;INTERVAL=1'
   ); 
END;