Hi,
Can anyone tell me the Command used to count the number of jobs in Datastage.
Number of jobs in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There isn't one.
From the Administrator client command window you can execute a query in the project to which you're actually connected, counting rows from DS_JOBS whose keys do not begin with "\\" and whose job type is not "sequence". But that's the count only for one project. You would need to do the same in all projects and sum the counts for "number of jobs in DataStage.
And that's just on your server. What about your other servers? What about every other DataStage installation on the planet and elsewhere? To get "number of jobs in DataStage" you'd have to count all the jobs in them too.
From the Administrator client command window you can execute a query in the project to which you're actually connected, counting rows from DS_JOBS whose keys do not begin with "\\" and whose job type is not "sequence". But that's the count only for one project. You would need to do the same in all projects and sum the counts for "number of jobs in DataStage.
And that's just on your server. What about your other servers? What about every other DataStage installation on the planet and elsewhere? To get "number of jobs in DataStage" you'd have to count all the jobs in them too.
Last edited by ray.wurlod on Tue Mar 24, 2009 1:59 pm, edited 1 time in total.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: