We have a number of cases in our development environment where Matillion jobs "go rogue" and need to be terminated. I don't see a way to get a list of all running jobs and then terminate the ones I choose. We are running Matillion ETL v1.58 for Snowflake on Azure.
Thanks, @Bryan - that could be very useful for the individual developer using the UI to run her jobs, but what about when someone in our Operations group wishes to programmatically list and then terminate selected jobs? Is there a set of API calls that can be used for that?
Hi @FredKoenders,
Yes, there are API's that all you to manage your jobs. We built a shared job which leverages the API to get all running jobs on the instance. Basically, you leverage this endpoint (https://documentation.matillion.com/docs/2949951) to get the Groups and Projects, then iterate over the them while using the this API endpoint (https://documentation.matillion.com/docs/2972278#1-1) to get any running jobs. You could then leverage this API endpoint to cancel them if needed (https://documentation.matillion.com/docs/2972278#2-2).
Hopefully this helps get you going.
@Bryan - Thanks for those links! This is exactly what I'm after, I think based on your information I can get a team working on an operations dashboard for our Matillion instances - dev/uat/prod.