Is there a utility or SQL I can use to find jobs that are long running jobs?

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• CA Workload Automation Agent

Issue/Introduction

Introduction: 

Is there a utility or SQL I can use to find jobs that are long running jobs?

 

Question: 

I need to create a new Autosys job which will check for the long running jobs (more than 45 minutes) and send mail to the application team. 

Wanted to know if there is any inbuilt utility I can use. 

 

Environment:  

Autosys: 11.3.5, 11.3.6

Opsys: All

 

Answer: 

There is no command line option to do this. I did write an sql that will do what you ask to get the jobs that have been running for over 45 mins:

 

select j.job_name from ujo_job j inner join ujo_job_runs r on j.joid=r.joid where r.runtime > 45; 

 

 

 

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: