select * from ( select ro.*,sj.id as sj_id, sj.groupid, sd.id as sd_id,sd.jobID, sd.type as sd_type, sd.intervl,sd.startDelay, sd.cronExpression, sd.enabled as sd_enabled, sd.nextFireTime, md.viewdef from "SYSADMIN.RecommendedOptimizations" ro join "SYSADMIN.ScheduleJobs" sj on ro.id = sj.groupid join "SYSADMIN.Schedules" sd on sj.id = sd.jobid,
texttable (
ro.MatchDescriptor
COLUMNS
"viewdef" string,
"second" string,
"third" string
DELIMITER' '
) md ) data
join
sysadmin.viewdefinitions vd
on vd.name = data.viewdef order by lastused asc
Comments
0 comments
Please sign in to leave a comment.