Sunday 10 January 2016

AD Jobs running more than 1 hour

Below script to know AD jobs running more than 1 hour.

Script:

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:

Post a Comment