Schedule a Maximo escalation for multiple days?

254 views Asked by At

Dear Stackoverflow community,

In Maximo (IBM Control Desk) I have an escalation that I would like to run on 00:00 (midnight) on Tuesday and on Thursday. Using the GUI, I can only select one day and not two.

GUI : Every (om de) 1 week (weken) on (op dag) Tuesday (dinsdag) at (op tijdstip) 00:00:00

enter image description here

This gives me the following expression:

1w,0,0,0,*,*,*,3,*,*

After Googling a bit I found that this should let me schedule a task on both days at 00:00 :

0 0 * * 2,4 

But Maximo will not let me add the above giving me an error (and returns to the previously expression) :

enter image description here

This lets me to believe that the cron expression I found on the internet and the expressions that are generated by Maximo have a different format.

How would I, in Maximo, set the proper expression for it to run on Tuesday and Wednesday 00:00?

Thanks in advance.

1

There are 1 answers

0
Niek Jonkman On BEST ANSWER

Thanks to the comments under the post, I decided to change the query of the escalations to check for the day in the week. I have added the following line of code:

and ( dayofweek(current timestamp) = 3 or dayofweek(current timestamp) = 5 )

Source: https://www.w3schools.com/mysql/func_mysql_dayofweek.asp

1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday.