DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, July 2, 2013

Script to check AD Jobs which runs more than 60mins


set lines 170
set pages 1000
select distinct t.job_name,
       TRUNC(t.ELAPSED_TIME * 24 * 60) MINUTES,
       t.PROGRAM_RUN_ID,
       t.product,
       t.start_time,
       t.end_time
  from applsys.AD_PROGRAM_RUN_TASK_JOBS t
 WHERE PROGRAM_RUN_ID in
       (select program_run_id
          from AD_PATCH_RUNS
         where patch_top like '/application_r12/apps/apps_st/appl/au/12.0.0/patch/115/driver')
 AND TRUNC(t.ELAPSED_TIME * 24 * 60) > 60
 ORDER BY 2 desc;

No comments: