Requirement:
In order to provide better system monitoring, a solution needs to be developed that will allow support staff to quickly and easily monitor the status for Maximo cron tasks and reports that are mission critical and need to run daily. This solution should have little impact on the Maximo system as well as easy to maintain. Currently when a cron task or report does not run, there is no way for the support staff to know this, aside from waiting for a user to call in a help desk ticket. This had caused cron tasks and reports to be down for days.
Solution:
Use the tools within Maximo to help monitor the status of cron tasks and reports. This can be done by creating a KPI for each cron task and report that needs to be monitored. These can then be added to the start center of the support status. This will allow the support status to log into the system daily and quickly see the status of those cron tasks and reports.
It is recommended that only a small set of cron tasks and reports be monitored in this way. These should be the most critical of job/reports. This will help the log in performance of the support staff.
Steps to fix:
Create a KPI for each cron task to be monitored (one for each cron task instance to be monitored):
KPI Name: Give it a unique name.
Description: Something like 'Number of days since <cron task name> has run".
Select: select sysdate - endtime from (select crontaskname,instancename, max(endtime) as endtime from crontaskhistory group by crontaskname,instancename)
Where: where crontaskname = '<cronTaskName>' and instancename = '<instanceName>'
Target: 0
Caution: 1
Alert: 1
Create a KPI for each Report to be monitored (one for each report to be monitored):
KPI Name: Give it a unique name.
Description: Something like 'Number of days since <Report name> has run".
Select: select sysdate - lastrundate from report
Where: where reportname = '<reportName>'
Target: 0
Caution: 1
Alert: 1
Then on the default start center for support staff, add the created KPIs. Now when the support staff logs in, they will see alerts for whenever a cron task/report did not run within the last day.
This example is set up for jobs that need to run everyday, but you could change this to monitor jobs that do not run as often by changing the Target, Caution and Alert values on the KPI to match the job schedule.
Happy Coding
No comments:
Post a Comment