Check a Pentaho result every 30 minutes and run other steps

Question

I am new to Pentaho. I currently has a job like this:

condition 1 -> condition 2 -> if successful then run this sql scripts, if failed then send email

I would like to have a loop that is more like:

(condition 1 -> condition -> 2) are run every 30 minutes 
-> if successful then run the sql scripts  and stop going back to conditions to check
-> if failed then loop back and run in the next interval

Is this possible to achieve?

Many thanks!

score 1 · Answer 1 · answered May 26 '22 at 12:44

1

You can do it with a job. See screenshots.

You'll need to replace the simple evaluation step by your condition checking routine.

answered May 26 '22 at 12:44

nsousa

4,448
1
10
15

Hello thank you for your answer. How do I set the Start? Should it be no scheduling and just run once? – hhp May 27 '22 at 10:37
Call it from the command line? – nsousa Jun 01 '22 at 06:20

score 0 · Answer 2 · answered May 26 '22 at 09:37

0

You could program a job to run every 30 minutes and add a step generating a file or inserting/updating a DB table that you could use to check if you need to run the conditions or not.

answered May 26 '22 at 09:37

Ana GH

1,397
1
9
19

Check a Pentaho result every 30 minutes and run other steps

2 Answers2