DSXchange

Posted: **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

Posted: **Tue Mar 03, 2009 3:45 pm**

It counts all jobs, including sequence jobs.

Posted: **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.

Posted: **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;

DSXchange

Count of number of jobs

Count of number of jobs