I use autosys R11 for my scheduling and have around 1000 jobs. How do I identify list of all jobs that are in running state for more than 4 hours ?
you will need to write code then. i believe WCC has a few reports etc as well..
I have done similar at client sights..
hope that helps..
If you have WCC you can have a view of jobs in RUNNING state, or you can do an autorep and grep " RU "
then there's JAWS etc.. or max_run_alarm etc etc etc.
It all depends what the use case is..
My purpose is to identify all the jobs running longer than 4 hours and generate a report with the list of the jobs using autorep
Can you help me with the sample snippet of pulling the job list?
My time is limited and I cannot garrantee results for you environment
perhaps your autosys admin/engineer would be able to assist.
e.g of autorep --
autorep -J ALL | egrep " RU "
It's expensive.. depending on how many jobs etc..
once you do that you need to look at the times.. otherwise there's the DB but those selects need to be tested depending on database type etc.. and you need to understand the table structures.. hence having the autosys resource do this is your best bet.
Otherwise as i said WCC has reports .. you may want to rey those first ...
Hope that helps..
You could perform an sql-select I believe against dbo.ujo_avg_job_runs in AEDB where the value in the column avg_run_time exceeds a certain value you decide.
Retrieving data ...