Re: problem by runing a job

On Thu, 17 Jan 2002 16:40:50 +0100, Thao Ngo <Thao.Ngo_at_t-systems.de> wrote:

>Hello NGs,
>
>I have a problem by runing a job.
>I was logged as "System" and want to run the broken job from any user by
>
>using the job identifier.
>
>DBMS_JOB.RUN(1);
>
>The created error message after runing the job is:
>"
> ORA-12011: 1 Jobs could not executed
> ORA-06512: in "SYS.DBMS_IJOB", row 394
> ORA-06512: in "SYS.DBMS_JOB", row 267
> ORA-06512: in row 1
> "
>
>Can you tell me, what this error message means and how to solve this
>problem.
>
>Thanks for any good tips.
>Thao
>
>

You can't. Only the owner of a job can modify it. You could of course write a pl/sql procedure in system (better submit that job using a different owner) and grant execute to public for that procedure.
The meaning of an error message generally speaking can be looked up in docs (Yes, I know many people here expect the people responding to look it up for them)

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 17 2002 - 11:54:28 CST