An interesting feature of Maximo crontask is the capability of storing the task execution times. This feature must be enabled in each crontask clicking on ‘Keep history’ checkbox. This is nice feature but Maximo does not provide a graphical tool to analyze crontask performances and execution times so i have prepared a small set of SQL queries to be able to quickly gather important statistics directly from Maximo’s database.
The first one extracts the start time and duration (in seconds) of each crontask execution in the last week.
to_char(starttime,'YYYY-MM-DD HH24:MI:SS') as starttime,
(endtime-starttime) as duration
order by starttime;
I typically import the output of this query into an Excel spreadsheet and analyze it sorting by whatever column I need. Furthermore, you can create a pivot table or chart to analyze the data. This is an example of what can be achieved:
If you are not familiar with Excel, here is a query that generates the same output straight from an SQL query:
sum(endtime-starttime) as totalduration
group by crontaskname;
One thought on “Crontask analysis and optimization”
Is there any approach to monitor cron task execution and have notifications sent if any cron doesnt start on time or get errored out ?