We are building a Data Warehouse on Synapse using ETL. We need a way to stop and start activities automatically in case of issues or during deployments, as the current manual disable/enable option is impractical for production.

Is there an alternative method to automate this?

Would a PowerShell command be available to enable/disable activities?

We also considered using an If condition with a control table to check each activity, but this seems too complex.