OraFAQ Forum: General » JOBS in Oracle using DBMS

Home » Other » General » JOBS in Oracle using DBMS_JOB (ORACLE 9, Win XP)

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

JOBS in Oracle using DBMS_JOB [message #295879]

Wed, 23 January 2008 16:29

Krann
Messages: 4
Registered: December 2007

Junior Member

Hi, i am new using DBMS_JOB package.

I want to know if the jobs need admin pivilegies to run in an time interval, because a made one but only run if i use the method

DBMS_job.RUN(jobID)

the code of my job is:

declare
jobID int;
begin
dbms_job.Submit(jobID,
'begin myProcWithOptParameters(); end;',
sysdate,'sysdate+(16/1440)',
false);
end;

Thanks for your help.

Krann.

[Updated on: Thu, 24 January 2008 09:19] by Moderator

Report message to a moderator

Re: JOBS in Oracle [message #295928 is a reply to message #295879]

Wed, 23 January 2008 23:24

Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes the owner of the job must DIRECTLY (not via a role) have the privileges to execute the work.

Regards
Michel

Report message to a moderator

Re: JOBS in Oracle [message #295985 is a reply to message #295879]

Thu, 24 January 2008 01:51

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Misunderstood about the content on Seeing the Title

"JOBs in Oracle" Under General Category Smile

Rajuvan.

Report message to a moderator

Previous Topic:	Linux to windows
Next Topic:	Database change/release management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 18:04:50 CDT 2024