-
Hi
I need to schedule a procedure using dbms_job.
I created it using the following script.
declare
jobno number;
begin
dbms_job.submit(jobno,'SP_PRE;', sysdate+1/1400,'sysdate+1/1400');
commit;
end;
When I check the user_jobs, the next_date column shows the process is due to run in a minute but its not executing at all. Where us If I use DBMS_JOB.RUN(1), its executing the procedure SP_PRE.
In init.ora, I have the following setting
job_queue_processes = 4
job_queue_interval = 60
Any thoughts?
Thanks
Raj
-
How do you know the job is not executed? Is last_date in user_jobs null?
Maybe an error occured, broken in user_jobs is 'N', and failures is 0?
Maybe others jobs are running.
-
I am sure its not executed. In the User_jobs, Broken is having 'N' , Failures is 0 and total_time=0.
-
If last_date is null the job is not executed, but if it is not null it is executed.
-
Did you restart your database after changing the init.ora parameters? It's only then that the init.ora is read...
Monika
-
Monika
Yes. Before I scheduled the procedure, I restarted the instance after changing the init.ora parameters.
Raj
[Edited by g_raju on 11-23-2000 at 07:14 AM]
-
-
Checked up with DBA_JOBS. Its no different from USER_JOBS.
-
Check in dba_jobs_running if no other jobs are running, taking all the queue_processes up.
-
I checked up dba_jobs_running. It has no rows on it.
Raj
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|