Re: Question of dbms_job

"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 - 10:09:09 CST