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

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't execute a scheduled job

Re: Can't execute a scheduled job

From: Matt Smith <m.smith_at_secureinteractive.com>
Date: Fri, 8 Jun 2001 08:49:34 +1000
Message-ID: <9fp06q$6lg$1@thebe.syd.dav.net.au>

Yep, that was it. The user has the DBA role, so I assumed that because I could execute the procedure from sqlplus that the queue would also be able to execute it. It seems that I have found out the hard way that the job queue doesn't recognise roles.

Thanks for your response.

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:o0pvhtg97oqgnrahqll5b6j07rh1u47cl4_at_4ax.com...
> On Tue, 5 Jun 2001 14:38:26 +1000, "Matt Smith"
> <m.smith_at_secureinteractive.com> wrote:
>
> At a guess, you need to grant execute privilege on sscc.expire_content
> to the schema running the job
>
> >I have a procedure called sscc.expire_content, which I want to run every
> >day. I have scheduled it in the job queue using the following SQL:
> >
> >--------------
> >VARIABLE jobno NUMBER;
> >BEGIN
> > DBMS_JOB.SUBMIT(:jobno,
> > 'SSCC.EXPIRE_CONTENT;',
> > TO_DATE('00:01:00', 'HH24:MI:SS'),
> > 'SYSDATE + 1');
> >END;
> >---------------
> >
> >If I run the procedure directly from sqlplus with 'execute
> >sscc.expire_content', it runs fine. If I force the job with 'execute
> >dbms_job.run(38)', it fails. It also fails when it is scheduled to run.
> >The following is what appears in the alert log:
> >
> >--------------
> >Tue Jun 05 12:19:52 2001
> >Errors in file D:\Oracle\admin\gedb\udump\ORA00357.TRC:
> >ORA-12012: error on auto execute of job 38
> >ORA-06550: line 1, column 96:
> >PLS-00201: identifier 'SSCC.EXPIRE_CONTENT' must be declared
> >ORA-06550: line 1, column 96:
> >PL/SQL: Statement ignored
> >--------------
> >
> >Why does it say that the identifier must be declared? I copied all the
> >syntax directly from the documentation. Any help here would be muchly
> >appreciated.
> >
> >Oh, yeah - almost forgot. I am running Oracle8i on NT4
> >
> >Thanks,
> >Matt
> >
>
>
Received on Thu Jun 07 2001 - 17:49:34 CDT

Original text of this message

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