Home » Other » General » JOBS in Oracle using DBMS_JOB (ORACLE 9, Win XP)
JOBS in Oracle using DBMS_JOB [message #295879] Wed, 23 January 2008 16:29 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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
Re: JOBS in Oracle [message #295985 is a reply to message #295879] Thu, 24 January 2008 01:51 Go to previous message
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

Thumbs Up
Rajuvan.
Previous Topic: Puzzle n°08 - Display the Numerical Pyramid using straight SQL query (Not PL/SQL) **
Next Topic: Database change/release management
Goto Forum:
  


Current Time: Sat Dec 03 11:51:42 CST 2016

Total time taken to generate the page: 0.03288 seconds