Re: Question of dbms_job

www.twisted-nail.com wrote:
> 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)

Please don't top post.

Two comments:
1. This doesn't address the OP's question 2. You do this in spite of the fact that there is a view named

    DBA_JOB_RUNNING. Why?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)