Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Followup to jobs not running

Re: Followup to jobs not running

From: Jerome Roa <jroa_at_uchicago.edu>
Date: Mon, 31 Mar 2003 13:43:36 -0800
Message-ID: <F001.00576ADD.20030331134336@fatcity.com>


should have bought the blue!!!

At 12:04 PM 3/28/03 -0800, you wrote:
>Privileges should be granted to the user, who created the job.
>Was it "system"?
>
>Igor Neyman, OCP DBA
>ineyman_at_perceptron.com
>
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Friday, March 28, 2003 2:13 PM
>
>
> > 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jerome Roa
  INET: jroa_at_uchicago.edu

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 Mon Mar 31 2003 - 15:43:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US