Solved

Monitoring Project conditional schedule

  • 4 March 2024
  • 2 replies
  • 26 views

Userlevel 1
Badge +1

Hello,

I have a monitoring project, and inside, there is a table (operations). This table is populated by ETL daily, and every day the ETL job finishes at a different time. That's why I can't assign a specific schedule to this monitoring project. There is another table (job_status) that shows the condition of the ETL job. Inside that table, there is a column named 'Status of ETL JOB'. If the value in that column is 'Completed,' then it means the job has completed, and now the monitoring project can be run. How can I create such a schedule for that MP?

I would be grateful if you can help me.

 

Thanks in advance.

icon

Best answer by anna.spakova 5 March 2024, 17:00

View original

2 replies

Userlevel 5
Badge +8

Hello @aysel_jafarzade ,

 

currently, there is no option how to create the scheduler conditional in this manner. What you can do is build a workflow in the orchestration server, that can run every 5 minutes (for example), check the table for the value, and if the value arrives, it will trigger the monitoring project via API: https://docs.ataccama.com/one/latest/one-apis/one-api.html#run-a-monitoring-project

If more details are needed, let me know.

Kind regards,

Anna

Userlevel 1
Badge +1

Thanks a lot, @anna.spakova 

Reply