Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Followup to jobs not running
Privileges should be granted to the user, who created the job.
Was it "system"?
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
> I changed the job_queue_processes (thanks Barbara), and the jobs all
started running, but they are not successful from within the job_queue.
They are jobs to gather schema stats using dbs_stats and are run as the
system user. I can run the what of the jobs within sqlplus successfully,
but whether I run the job manually or the job_queue runs the job, it is
still failing. The error I see is insuffient privileges, but I have tried
specifically granting execute on dbms_stats to system. Is there anything
else I should look for?
>
> Terry Ball, DBA
> Birch Telecom
> Work: 816-300-1335
> FAX: 816-300-1800
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ball, Terry
> INET: TBall_at_birch.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: ineyman_at_perceptron.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Mar 28 2003 - 14:04:07 CST
![]() |
![]() |