可以对元数据库表data_source来进行分析。SQL如下:
select ds_id,JSON_EXTRACT(config, '$.enableSchedule'),cron from data_source
where is_del = 0 and cron is not null and (JSON_EXTRACT(config, '$.enableSchedule') is null or JSON_EXTRACT(config, '$.enableSchedule') = true); |