Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question of dbms_job

Re: Question of dbms_job

From: Michel Cadot <micadot{at}altern{dot}org_at_nirgendwo.no-spam.invalid>
Date: 08 Dec 2005 21:23:18 GMT
Message-ID: <4398a446$0$42934$892e7fe2@authen.yellow.readfreenews.net> 





"www.twisted-nail.com" <primoz.mihelic_at_email.si> a écrit dans le
message de news: 


1134048347.432122.189400_at_g43g2000cwa.googlegroups.com...


| Hi,

|

| I use the following sql to get jobs which are currently executing:

| SELECT j.log_user username, s.sid, s.serial#, j.job, j.broken,

| j.failures, j.WHAT

|  FROM dba_jobs j,

|       v$session s

| WHERE exists(select 1

|               from v$lock v

|              where v.type = 'JQ'

|                and id2=j.job

|                and s.sid=v.sid)

|

| Best regards,

| Primoz

|




And this gives you "when the job is created"?



Regards


Michel Cadot
Received on Thu Dec 08 2005 - 15:23:18 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US