dms_job and "user owner"

From: <mecolik_at_my-deja.com>
Date: Mon, 21 Feb 2000 13:53:22 GMT
Message-ID: <88rg0h$2rg$1@nnrp1.deja.com>

Hello,
I got a problem with dbms_job :

to be sure that my job exists on the DB, I'd like to check via user_jobs the existence of the job.

This thing goes very well on sql*plus but when I run it trought my application, things goes wrong, the user_jobs returns me no job. It seems the job is launched or owned by another user (seems possible because the app is launched via a DAD, and we are using multiple schema to inforce security).
Is there a easy way to check the user_jobs view of another schema ? (without a sys grant , I mean)
Or do you see another solution ?

Thks,

Henri Chapelle
hch_at_europay.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Feb 21 2000 - 07:53:22 CST