Count of number of jobs

vij · Post by **vij** » Tue Mar 03, 2009 3:37 pm

Hi,

How do I take the count of number of jobs and sequencers in datastage? I tried the following command from datastage Administrator. I got a count and I believe the count is only for the jobs.

SELECT COUNT(*) FROM DS_JOBS

If this does not count the sequencers, how do I do get the sequencer counts?

Thanks in advance!
Vijayalakshmi

DSguru2B · Post by **DSguru2B** » Tue Mar 03, 2009 3:45 pm

It counts all jobs, including sequence jobs.

kduke · Post by **kduke** » Tue Mar 03, 2009 3:57 pm

Do a search. This has been answered several times. There is a job type field in DS_JOBS.

ray.wurlod · Post by **ray.wurlod** » Tue Mar 03, 2009 5:09 pm

It also counts all the control records (such as category definitions).

You need to constrain the query to eliminate these.

Code: Select all

SELECT JOBTYPEIND, COUNT(*) FROM DS_JOBS WHERE NAME NOT LIKE '//%' GROUP BY JOBTYPEIND;