Re: Use of DBMS_JOB package

Hi Dave,

use USER_JOBS table. Note that you will have to connect as job owner to see the jobs.

Hope this helps,
Igor

Dave Morris wrote:
>
> All,
> Could someone tell me how to view a list of jobs submitted using :
> execute dbms_job.submit(and the rest ...).
> I gather the command to remove jobs is
> execute dbms_job.remove(number)
> but how do I find out what jobs have been submitted and their job
> numbers ?
>
> Thanks
>
> Dave

--
Igor Sereda,
ITC, Russia Received on Tue May 05 1998 - 15:13:11 CDT