Re: Question of dbms_job

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

http://www.twisted-nail.com

DA Morgan je napisal:
> Mike wrote:
> > Do you know which view i can select from to know WHEN the job is
> > created?
> >
> > Thanks in advance.
> > -Mike
>
> Your only choices are:
> job$
> user_jobs / all_jobs / dba_jobs
> user_jobs_running / all_jobs_running / dba_jobs_running
>
> Not sure if the will contain what you want.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Thu Dec 08 2005 - 07:25:47 CST