67,513
社区成员
发帖
与我相关
我的任务
分享
select job.ID as jid,job.MEMEO as jmemeo,job.CONFIG_PATH as jconfigPath,job.JOB_XML as jjobXml,conf.SQL_CONTENT as csqlCoilentent,input.FILE_NAME as ifileName,exp.FILE_NAME as efileName,exp.FILE_PATH as efPath,conf.TIME_LAG as ctimeLag,syscode.isValidator_Id as jisValidateId,syscode.isValidator_Name as jisValidatorName,syscode.type_Id as jTypeId,syscode.type_Name as jTypeName,syscode.cycle_Id as ccycleId,syscode.cycle_Name as ccycleName
from
(select cycle.cjobName as cycle_Name,cycle.cjobId as cycle_Id,type.cjobName as type_Name,type.cjobId as type_Id,validator.cjobName as isValidator_Name,validator.cjobId as isValidator_Id
from (
select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='任务周期' and codes.ITEM_VALUE='1'
) as cycle,
(
select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='任务类型' and codes.ITEM_VALUE='0'
) as type,
(
select codes.ITEM_NAME as cjobName,codes.ITEM_VALUE as cjobId from mng.t_sys_codeset as codeset,mng.t_sys_code as codes where codeset.ID=codes.CS_ID and codeset.CN_NAME='是否模式' and codes.ITEM_VALUE='1'
) as validator
)as syscode,MNG.T_HADOOPETL_JOB as job,mng.t_cloudetl_jobconf as conf,mng.t_cloudetl_jobinput as input,mng.t_cloudetl_jobexp as exp
where 1=1 and job.ID=conf.JOB_ID and job.ID=input.JOB_ID and job.ID=exp.JOB_ID and job.IS_VALIDATE=syscode.isValidator_Id and job.JOB_TYPE = syscode.type_Id and conf.CYCLE=syscode.cycle_Id and job.ID =32