DBMS.JOB -> start procedure

From: robert <newsreply_at_#removethis#cookiesoftware.nl>
Date: Sun, 3 Nov 2002 19:50:00 +0100
Message-ID: <aq3rik$8ln$1@reader13.wxs.nl>

Hi there,

I have a few question on dbms jobs.
1.How do i start a procedure from a job ?

No extra code, just 1 stored procedure ?? I can start the fucntion by inserting the pl/sql definition of the function, but i just want to call it.

2 On which schema are dbms jobs executed. (concerning grants and roles ofcourse)

The procedure i would like to call is NOT in the sys schema. Should it be ?

Thanks in advance,

Robert Received on Sun Nov 03 2002 - 12:50:00 CST