Hello,

I think the easiest option would be just to schedule extraction of additional table/view, that would log job status. If it would have status "completed" and date would be same day, you could just trigger data model load. I think in order to pull it off, you would use the signals/action engine.

The table with job logs would be used as signal table, and filtered (status job, and job date, maybe job name/job type).

After specific ssms data job that's related to Celonis would end, the new signal would be created. That signal should be input for Skill that would trigger the Data model Reload.

Help:

<celonis_link>/help/display/CIBC/Celonis+Actions#CelonisActions-action3ReloadDataModel

<celonis_link>/help/pages/viewpage.action?pageId=16482515

I think here you can a related question the in link below (however it may be outdated):

https://www.celopeers.com/s/question/0D50700000GC73LCAT/use-celonis-external-trigger

Best Regards,

Mateusz Dudek