Jobs with no design time information
Posted: Mon Nov 22, 2004 7:13 pm
The following query will identify jobs with no design time information.
So will this query.
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.
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'";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.