Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this procedure running ?
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 11 1998 - 00:00:00 CST