dolphinscheduler查询mysql中任务sql

泡椒炒甜瓜 / 2024-10-11 / 原文

表名:ads_ctal_da

根据表名查询涉及表所在的任务

select 
t_ds_project.name 
,t_ds_task_definition.* 
from t_ds_task_definition
left join t_ds_project on t_ds_task_definition.project_code  = t_ds_project.code 
where  
-- task_type  = 'sql' and
 task_params like '%ads_ctal_da%'
order by task_type ;