The Escalation Setup below is an example of being notified for a Workorder status Change, this will send the Role/Person specified on the Communication Template an email everytime someone changes a WORKORDER to APPR.
First thing to do is to make sure that you have setup your email settings in the System Properties. Go ahead and set the mxe.smtp.host setting and the mxe.workflow.admin setting. You may have to restart the application server for the settings to take effect.
Create a escalation and fill in the following fields
Applies to :WORKORDER
Condition: STATUS='APPR' and STATUSDATE >=(getdate() -1/1440)
Schedule: 1 minute
Escalation Point section:
Elapsed Time Attribute: STATUSDATE
Escalation Point condition: 1=1
Check Repeats Box
Attached a Communication Template to my Notification Section
Communication Template specifics;
Applies to : WORKORDER
Accessible From: ALL
To: Role you choose
Send From: Maximo Administrator
Subject: :WONUM has changed status
Message: The :WONUM has been changed status to :STATUS on :STATUSDATE
****NOTE: Now the REPEATS need to be checked in order for it to notify you on the same Workorder being changed to APPR back to WAPPR back to APPR…..
The following query STATUSDATE >=(getdate() -1/1440)
this will check when a STATUSDATE is changed within that last minute…
Sysdate means it checks the Date on the Server
-1 means it will check for any changes to the STATUSDATE within the last minute the crontask was running as the schedule is every minute
1440 is the following calculation
1440 divided by 60 Seconds ( 1minute)= 24 HOURS
24 Hours X 60 Seconds= 1440
So the Crontask runs every minute…but only will send an email when a Workorders STATUSDATE is changed within the last time it ran and the Workorder is changed to APPR…
Apologize if I'm not even close to what you are asking for.
Adam