Infomart 8 run schedule non-stop

[Marco64]

Infomart version 8.x

The customer wants that the Infomart job (Load and Transform) will run continuously (no stop)

In schedule section we handled the options in this way.

[schedule]
etl-end-time=06:00
etl-start-time= 06:00

but even so the schedule does not seems to be running over the 24 hours. Seeing Extract and Transform Jobs from the GUI will show that these stop at 4AM.

The options are as follows:

[schedule]
aggregate-duration=23:00
aggregate-schedule=0 4
etl-end-time=12:05
etl-frequency=1
etl-start-time=12:05
maintain-start-time=03:00
run-aggregates=true
run-maintain=true
run-scheduler=true
timezone=GMT
 
the application was restarted and we re-enabled the run-scheduler and run-aggregates.

There is something else tht needs to be handled? maybe the aggregation schedule? (how)

Tks Marco

[Adam_W]

If you want to run the ETL continuously, you would need to set the start and stop options something like the following:

etl-start-time = 00:01
etl-end-time = 23:59

However, your MaintainGIM job must run outside of the ETL window, so you would need to have at least a short gap to allow this to run.

Also, the ETL is currently set to run once every minute, which is probably excessive and could easily be relaxed to at least 15 mins.

Do they really need the ETL to run constantly?  Are they a 24/7 operation?

When do they do database backups?  Because those jobs should also be scheduled outside of the ETL window....

[Allan]

Hello,

You have asked for Infomart to run the aggregate job for 4 hours. This is from the option
aggregate-schedule 0 4.

Therefore the aggregate gim job is stopping at 4:00.

If you want this to run continuously then set this as follows:

aggregate-schedule 0 0
aggregate-duration 24:00

However bear in mind that running the jobs 24 hours per day is not advisable. This will leave no time for the daily jobs that will need to run in order to move the data from intra day tables to the historical tables.

Genesys PS will advise on the correct settings for your requirements or you can find this info in the manuals