.Hi,
My oracle db: 11G
I am using dbms_job.submit to schedule a job every 30 seconds. here is the associated code:
1) I executed this first:
set serveroutput on;
2)
I have created a simple procedure:
create procedure p_hello_world
as
begin
dbms_output.put_line('Hello World.');
end;
3) Now I have executed this anonymous block:
declare
job_number number := 1;
begin
dbms_job.submit(job_number, 'p_hello_world;',sysdate,'SYSDATE + 30/86400');
commit; -- I guess I need to commit;
end;
PS: I can see that the anonymous procedure executed successfully.
4)
I can see an entry in the table: user_jobs
Now I am just trying to understand:
a) is my job running already? or am I supposed to use some command to make it up and running?
b) I cannot see any output on console every 30 seconds
Any help is appreciated.
Thanks
Rahul