When enabling optimizations, you might want to make sure that each optimization has at least one schedule. This ensures that optimizations are refreshed regularly in order to return recent data.

For verifying that every optimizations is covered by a schedule, you can run the following code which will return all optimizations that currently lack a schedule:

SELECT ro.id

   ,ro.Matchdescriptor

   ,sj.description

   ,sd.*

 FROM

   "SYSADMIN.RecommendedOptimizations" ro

   left join "SYSADMIN.ScheduleJobs" sj

   on ro.id = sj.groupId

   left join "SYSADMIN.Schedules" sd

   on sj.ID = sd.jobID

 WHERE

   "ro"."Enabled" = true

   and sd.ID IS NULL;;