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;
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