SQL Monitor currently does not have customization on scheduling for custom metrics
SQL Monitor currently does not have customization on scheduling for custom metrics- only per min\5 min\hour basis.
the option to setup your own schedule could be given to users and setup your own frequency or metric collection.
-
Mark Freeman commented
I have 40 Azure SQL Databases in an Elastic Pool. I have a relatively resource-intensive custom metric I want to run daily. I want it to run outside of the work hours for the database users, and not at the same time in every database, which can cause problems at the pool level. Being able to set a timeout, a start time and either a delay between the execution in each database in the pool or a separate start time for each database would keep me from getting error alerts almost every day.