That did not help. It takes longer to error out, but it is still failing. I can set the same jobs up for the sys user and they run without problems. I am not sure why the system user is the owner of the jobs and since I am the only DBA here this afternoon, I will have to wait until next week to find out if there is a reason for not moving them to sys.
If anyone else has any ideas, I am still open to suggestions. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -----Original Message----- [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 1:42 PM To: Ball, Terry GRANT ANALYZE ANY TO SYSTEM; "Ball, Terry" <[EMAIL PROTECTED]> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Followup to jobs not running 03/28/2003 11:13 AM Please respond to ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Ball, Terry INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
