OraFAQ Forum: SQL & PL/SQL » dbms

Home » SQL & PL/SQL » SQL & PL/SQL » dbms_job.run

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_job.run [message #37240]

Sat, 26 January 2002 01:22

Vasea
Messages: 5
Registered: January 2002

Junior Member

I want to start a job:
variable job number;
begin
dbms_job.submit(:job,'add_user;',sysdate,'sysdate+1',true);
dbms_job.run(51,true);
end;

but take a message:
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 405
ORA-06512: at "SYS.DBMS_JOB", line 267
ORA-06512: at line 1

Report message to a moderator

Re: dbms_job.run [message #37242 is a reply to message #37240]

Sat, 26 January 2002 07:09

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

check snp trace file what is causing error

Report message to a moderator

Re: dbms_job.run [message #37253 is a reply to message #37240]

Sun, 27 January 2002 23:52

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

Hi,

try this and find out the error(i guess u do not have privillege to create user i.e. ORA-01031: insufficient privileges)

exec add_user;

cheers
pratap

Report message to a moderator

Re: dbms_job.run [message #39391 is a reply to message #37240]

Sun, 14 July 2002 05:33

nickleigh
Messages: 1
Registered: July 2002

Junior Member

1.add_user
2.51

Report message to a moderator

Previous Topic:	Upgradation
Next Topic:	External Proc Execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 31 21:24:49 CST 2025