Some users unable to submit via DBMS_JOB

[greg...@my-deja.com]

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.

[Mark Gumbs]

I'm not 100% sure but you may have to put your pl/sql in a
procedure/function and call that from dbms_job.

Also, you may not need quotes if using sysdate.

e.g

begin
dbms_job(1,'procedure',sysdate, sysdate + 1);
end;

Mark

greg...@my-deja.com wrote in message <7j3sdv$q0t$1...@nnrp1.deja.com>...

[Doug Cowles]

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.