Re: dbms_job

Joaquin Garcia Santos wrote:
>
> Hello,
> excuse my poor english.
>
> I have submitted a stored procedure using dbms_job. I want to know if there
> is some table where I can see the information about this process.
>
> Thanks a lot

select * from sys.user_jobs;
or
select * from sys.dba_jobs;

also can see which jobs are currently running with

select * from sys.dba_jobs_running;

hth,

Matt Received on Fri May 19 2000 - 00:00:00 CEST