How to obtain a list of running oracle scheduler jobs

This was actually given to me by a workmate (thanks Ramón). The SQL is simple and gives Oracleyou a list of all the Oracle scheduler jobs that are running in the system.

select
 rj.job_name,
 s.username,
 s.sid,
 s.serial#,
 p.spid,
 s.lockwait,
 s.logon_time
 from
 dba_scheduler_running_jobs rj,
 v$session s,
 v$process p
 where
 rj.session_id = s.sid
 and
 s.paddr = p.addr
 order by
 rj.job_name
 ;
Posted in Databases. Bookmark the permalink. RSS feed for this post. Leave a trackback.

Swedish Greys - a WordPress theme from Nordic Themepark.