Automic Workload Automation

Hi,

is there a possibility to determine automatically long running jobs, e.g. > 2 h ?

I do not want to modify all 2000 Jobs in the attribute tab of a job.

Greetings,

Mya

One way is an SQL query over your Automic database that reads the AH table, that's where the statistics of all your jobs are, for as long as your reorganisation process keeps them in the database.

AH_TIMESTAMP1 to AH_TIMESTAMP4 is Activation, Start, End and Deactivation, respectively. With those, you can get any rumtime criteria you want. You may need to map AH_OH_IDNR to the OH table's ID to get OH_NAME along with the results, which is the job's name.

Hth,

The AH table contains entries that have reached a certain point in processing and hold all job history, so you can identify jobs that have been running over any X time or X times the ERT, etc.  Jobs with the longest average runtime over the last 60 days with at least 6 instances and only those with a successful completion.

For current activity, you can either set a filter in the Activity Panel to only show jobs/flows etc that were started or activated prior to a specific time (more than 2 hours ago).

The EH table is the primary source for the Activity Panel, and has columns SIMILAR (not identical) to the AH table.  This would be a better source for running activity than AH, if the activity panel option does not work.