Re: Some users unable to submit via DBMS_JOB

There are a few parameters you have to set in order for DBMS_JOB to work right - job_queue_processes (10 max), job_queue_interval (interval to check) and job_queue_keep_connections = true. I don't know if this is your problem or not, but I had some jobs that weren't running and weren't showing up as broken because I forgot these parameters.

• Dc.

gregrahn_at_my-deja.com wrote:

> Here is my problem.
>
> Some users are able to sumbit a job via DBMS_JOB
> and others are not. I noticed that all the
> accounts created after a point in time
> ( the created col from dba_users )
> are unable to submit a job to the queue.
>
> The error returned is such:
>
> SQL> var jobno NUMBER
> SQL> BEGIN
> 2 DBMS_JOB.SUBMIT(:jobno,'BEGIN NULL;END;',SYSDATE,'SYSDATE+1');
> 3 END;
> 4 /
> BEGIN
> *
> ERROR at line 1:
> ORA-01403: no data found
> ORA-06512: at "SYS.DBMS_JOB", line 126
> ORA-06512: at line 2
>
> I did some mass account deletions and creations
> and am wondering if something got cheesed up in
> the internal tables.
>
> Any help would be appreciated!!
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jun 04 1999 - 11:10:15 CDT