Tuesday, July 22, 2014

Automation Script to Run Database scripts as a cron task



1. Create an automation script for Script with Action Launch Point

2. Map the action to any Object in Maximo. I am mapping it to COMPANIES.


 




 
3. Create an escalation for that object [COMPANIES] to schedule the Automation script like a cron task



Email from Maximo:
It confirms the Maximo Database is getting connected and pulls the record from COMPMASTER table with a SELECT query.



6 comments:

  1. Hi Surendar.. this is a great post to execute actionscript from escalation.
    I think this is similar to execute actionscript using cron task ( http://www-01.ibm.com/support/knowledgecenter/SS5RRF_7.6.0/com.ibm.mbs.doc/autoscript/t_cron_task_scripts.html ) but I dont know why in my maximo deployment, the com.ibm.tivoli.maximo.script.ScriptCrontask is not recognized yet... :(

    ReplyDelete
    Replies
    1. Hi Senasana, I didnt work on v7.6. It would be better if you give some log trace on why it is not recognized. we can debug it.

      Delete
    2. sorry, I mistype "actionscript", it should be automation script :) LOL
      Surendar, can we use that class in maximo 7.5 ? if yes, how to do that?

      Delete
    3. We cant use this class com.ibm.tivoli.maximo.script.ScriptCrontask in Maximo 7.5. it does nt have an option to configure cron task directly. In 7.5, we can achieve it by an action linked with escalation.

      Delete
  2. Not able to see What is the custom action is created in Action. Please suggest me how to refer the automation script in action.

    ReplyDelete
    Replies
    1. It's available in github in the last line of this post. You can refer the code from there.

      Delete