Jobs with no design time information

ray.wurlod · Post by **ray.wurlod** » Mon Nov 22, 2004 7:13 pm

The following query will identify jobs with no design time information.

SELECT NAME FMT '40L' 
from DS_JOBS 
where NAME NOT LIKE '\\%'   -- exclude category names and control records
and not exists (select NAME from DS_JOBOBJECTS where DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO)
HEADING "Jobs that have no design time information 'GTG' Page 'PLL'";

So will this query.

Code: Select all

SELECT NAME FMT '40L' 
from DS_JOBS 
where NAME NOT LIKE '\\%'   -- exclude category names and control records
and not exists (select NAME from DS_JOBOBJECTS where DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO)
HEADING "Jobs that have no design time information 'GTG' Page 'PLL'"
NO.INDEX;

If the results are different, you should allocate some time to rebuilding indexes at least on DS_JOBOBJECTS and DS_JOBS, ideally on the entire project.