Re: SQL script to see all concurrents

apogeusistemas_at_gmail.com wrote:
> DA Morgan wrote:
> > apogeusistemas_at_gmail.com wrote:
> > > Please, I'm looking for a SQL script to see all concurrents
> > > (running, pending and completion) in my Oracle system.
> > > regards.
> >
> > If you are referring to jobs, you don't say, look in DBMS_JOBS.
> >
> > In future posts please provide sufficient information for us to
> > know what you are doing an in what version you are doing it.
> > --
> > Daniel Morgan
> > University of Washington
> > Puget Sound Oracle Users Group
>
>
> Running this script that I got in a site works fine to me, I only need
> final jobs status. How enable it ?
>
> set echo off
> set feedback off
> set linesize 97
> set verify off
> col request_id format 9999999999 heading "Request ID"
> col exec_time format 999999999 heading "Exec Time|(Minutes)"
> col start_date format a10 heading "Start Date"
> col conc_prog format a20 heading "Conc Program Name"
> col user_conc_prog format a40 trunc heading "User Program Name"
> spool long_running_cr.lst
> SELECT
> fcr.request_id request_id,
>
> TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60)
> exec_time,
> fcr.actual_start_date start_date,
> fcp.concurrent_program_name conc_prog,
> fcpt.user_concurrent_program_name user_conc_prog
> FROM
> fnd_concurrent_programs fcp,
> fnd_concurrent_programs_tl fcpt,
> fnd_concurrent_requests fcr
> WHERE
>
> TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60) >
> NVL('&min',45)
> and
> fcr.concurrent_program_id = fcp.concurrent_program_id
> and
> fcr.program_application_id = fcp.application_id
> and
> fcr.concurrent_program_id = fcpt.concurrent_program_id
> and
> fcr.program_application_id = fcpt.application_id
> and
> fcpt.language = USERENV('Lang')
> ORDER BY
>
> TRUNC(((fcr.actual_completion_date-fcr.actual_start_date)/(1/24))*60)
> desc;
>
> spool off
>
>
> Request ID (Minutes) Start Date Conc Program Name User Program
> Name
> ----------- ---------- ---------- --------------------
> --------------------------------------
> 1445627 218 01-SEP-02 MWCRMRGA Margin Analysis
> Report(COGS Breakups)
> 444965 211 03-JUL-01 CSTRBICR5G Cost Rollup - No
> Report GUI
>
>
>
>
> Thanks

That is an Oracle Apps ERP query. I used to work with it, but I have since gotten rid of that stuff. Why not run a report and trace it? I used to get all kinds of useful stuff in Apps when I did that. I do remember a column in FND_CONCURRENT_REQUESTS for status, though. That is probably what you want.

HTH, Steve Received on Thu Sep 21 2006 - 09:51:21 CDT