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

Document ID : KB000039819
Last Modified Date : 14/02/2018
Show Technical Document Details

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;