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
Count of number of jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It also counts all the control records (such as category definitions).
You need to constrain the query to eliminate these.
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;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.