Re: Is this procedure running ?

This is not true.
User_JOBS shows olnly shows jobs submitted using the package dbms_job or things like snapshot refresh jobs etc.

Cheers
Sanjay Mathew

Young-chul,Jun wrote:

> There is USER_JOBS view.
> User_jobs's what column contain procedure name information.
> Thanks.
>
> Young-chul,Jun ycjun_at_samsung.co.kr
> SAMSUNG SDS KOREA
>
> Luis Gregorio ÀÌ(°¡) <6e3prn$gb0$1_at_duke.telepac.pt> ¸Þ½ÃÁö¿¡¼­
> ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
> >My question is: Is there anyway of knowing if a certain procedure is
 already
> >running?
> >
> >I want to create a procedure to do a specific job everytime it is called,
> >but if when it's called it's already running I dont want to execute the
> >procedure again.
> >
> >Does existe any view or table where I can find this information? Or do I
> >have to build same kind of algorithm to go around the problem ?
> >
> >Every sugestion is welcome.
> >
> >Thanks in advance:
> >Luis Gregorio
> >
> >
Received on Wed Mar 25 1998 - 00:00:00 CST