DBMS_JOB

[g_raju]

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

[akkerend]

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.

[g_raju]

I am sure its not executed. In the User_jobs, Broken is having 'N' , Failures is 0 and total_time=0.

[akkerend]

If last_date is null the job is not executed, but if it is not null it is executed.

[Monika]

Did you restart your database after changing the init.ora parameters? It's only then that the init.ora is read...

[g_raju]

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]

[ligang]

Check DBA_JOBS

[g_raju]

Checked up with DBA_JOBS. Its no different from USER_JOBS.

[rschulze]

Check in dba_jobs_running if no other jobs are running, taking all the queue_processes up.

[g_raju]

I checked up dba_jobs_running. It has no rows on it.


Raj